When will macro in module run when Application.EnableEvents is set to False?

Hi,

I have a worksheet with a number of macros in it that run when a value in the worksheet changes. For each of these macros, I have set

Please Login or Register  to view this content.

and the last line of the macro is

Please Login or Register  to view this content.

My questions is if another macro within a module is called while the worksheet change macro is running, will it immediately run after the worksheet change macro or will it be completely ignored and will have to be called again at such time when on of the worksheet change macros are not running?

Many thanks in advance for your help,

twills

Events relate to specific Events assigned to specific Objects.

For a Worksheet things like the Calculate event, SelectionChange event etc etc... "standard" macros are not affected by the temporary disabling of Events.

see: http://www.cpearson.com/excel/Events.aspx

Why disable them ?

It follows that if you're running a Change event and part of that event involved updating the value of the Target cell you would end up in a perpetual loop were you not to disable events beforehand