Application.EnableEvents Changes to False

**Rushti** · 11-30-2009, 10:26 AM

Thanks for the speedy reply

There is a class module which is used to ungroup sheets on sheet activate and sheetselectionchange.

This has been turned off while I fix the problem. These work before anything is pasted and leave application.enableevents = true when finished

**DonkeyOte** · 11-30-2009, 10:32 AM

the only thing that will be affecting the Events status is code... an event is firing somewhere ...

Being a bore... let's check things off:

a) ThisWorkbook checked and clear of code ?

b) If a) is yes then... from native XL right click on tab in question and select View Code - is that clear of code ?

If neither a) nor b) are throwing up code then I would assume the Class Module is the cause... use Immediate window to ensure Events are enabled before doing anything... then with Class Module supposedly out of action repeat the copy & paste ... now check events status again, what is the status ?

Also be sure that whatever error handlers you have in place are ensuring Events are reset prior to exiting routine...

**Rushti** · 11-30-2009, 10:47 AM

ThisWorkbook has code within it the Workbook_Open procedure.

Once the workbook opens and this code runs Application.EnableEvents = True.

The worksheet in question has no code in it.

I have found that it appears not only to be on paste but on any change Application.EnableEvents changes to false

I have completley removed the class module and any reference to it for the moment. The same problem is there.

Where should I look now?

Thanks

**Rushti** · 11-30-2009, 10:49 AM

Additionally, If I create a new workbook with my current one open, the same problem happens.

If I create a new workbook without the other open, there is no problem.

I hope this helps.

**Rushti** · 11-30-2009, 10:53 AM

Thank you Andy - That worked a treat.

There was a function which changed the application.enableevents to false.

Many Thanks for Everybodies Help

**Andy Pope** · 11-30-2009, 10:49 AM

You can also use the Watch window to help locate the change.

Add a watch to, Application.EnableEvents, in all procedures of all modules.
Break on change.