View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
 
Posts: 230
Default Deactivating all events in ThisWorkbook

True that this will disable events for the hidden sheet, but it will also
disable events for every sheet. So, if you don't want events to occur on the
hidden sheet, then prior to causing something that would start an event on
the hidden sheet, turn off events, then turn them back on once you are "done"
working on the hidden sheet, however, if the hidden sheet links to other
sheets, then you may run into other problems.

Then again, if there are particular events that you want to be able to
perform on the hidden sheet for given changes, then you can capture which
cell(s) have changed, and disable the particular event. (I think... I'm
wrapping myself around an axle thinking about this one.)
Good luck. :)

"JMB" wrote:

Try this:

Application.EnableEvents = False

"Gwen" wrote:

Hi,

Is there a code that can deactivating all events contained in the
ThisWorkbook hiddensheet?

Thanks.