Application.EnableEvents

[Terry]

Will the Application.EnableEvents method stop events from firing in any functions or subs call from
the procedure that sets that method, or do I need to include that in every function or sub that may
fire unwanted events?

Terry

 

[Chip Pearson]

Terry,

EnableEvents is a global setting, so it needs to be set (and
reset) only in the first procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Will the Application.EnableEvents method stop events from

firing in any functions or subs call from

the procedure that sets that method, or do I need to include

that in every function or sub that may

 

[Frank Kabel]

Hi Terry
has to be set only at the beginning as this is a global setting. Don't
forget to turn them on at the end of your last macro