Application.EnableEvents Changes to False

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

Hi,

I have a workbook which, when I paste into a cell, Application.EnableEvents changes to false.

I have found this by using the immediate window to print the status of the Application.EnableEvents:

When my workbook opens, it runs some code, when finished, the Application.EnableEvents = True

I click any cell on the sheet that is shown - Application.EnableEvents = True

I copy this cell (either by the ribbon or ctrl + c) Application.EnableEvents = True

I click another cell - Application.EnableEvents = True

I paste into this cell - Application.EnableEvents = False

I have no code that traps a ctrl + v or paste but require the enableevents not to be changed.

Does anybody have any ideas as to what could be the problem?

Many Thanks in Advance,

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

Have you checked to see if you have any Sheet object events like Change, Calculate etc firing either at Workbook or Sheet object level ?

**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.

**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.