I always turn off/on enableevents in my macros.
I use on error goto end, where I set enableevents=true
However, things may go wrong, and enableevents stays in false.
Is there any way to force enableevents=true when enabling macros?
Thanks!
I always turn off/on enableevents in my macros.
I use on error goto end, where I set enableevents=true
However, things may go wrong, and enableevents stays in false.
Is there any way to force enableevents=true when enabling macros?
Thanks!
What things go wrong that keep events off, sounds as if the error handling isn't quite right.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I will try to revie my error handling.
Apart from that, is it possible to force enable events=true?
Thanks
I'd do as XLD says and double check your error handling
When you open the workbook you can put this is standard module to at least enable events for the rest of the startup sequence
[VBA]
Option Explicit
Sub auto_open()
Application.EnableEvents = True
End Sub
[/VBA]
Paul