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.

It sure seems like a reasonable approach to me.

But I think the way you really find out if there's other problems is by testing
the heck out of it.



JakeyC wrote:

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.

--

Dave Peterson