Force enableventes=true

[rolo]

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!

[Bob Phillips]

What things go wrong that keep events off, sounds as if the error handling isn't quite right.

[rolo]

I will try to revie my error handling.
Apart from that, is it possible to force enable events=true?

Thanks

[Paul_Hossler]

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


Option Explicit
Sub auto_open()
Application.EnableEvents = True
End Sub


Paul