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!
Printable View
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.
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