Application.EnableEvents

T

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
 
C

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



Terry said:
Will the Application.EnableEvents method stop events from
Click to expand...
firing in any functions or subs call from
the procedure that sets that method, or do I need to include
Click to expand...
that in every function or sub that may
 
F

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
 
Top