Disabling Events: Dangerous?
I think I have this one sussed, but wanted to check that there are no
unexpected side-effects!
I have a workbook, which contains several macros. One of which is
triggered by the Workbook_Open event to 'initialise' the worksheets
before the user begins to change it.
During the initialisation, the Workbook_Open macro makes changes which
trigger other event macros, most of which mess up the sheet if they run
during the initialisation.
I assume that the following will stop any other macros running before
the Workbook_Open macro has stopped:
Application.EnableEvents = False
'initialize the Worksheets
Application.EnableEvents = True
But is there anything I've overlooked that might mess other things up?
Thanks for your help.
|