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

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" wrote in message
news:mWibc.166008$po.974684@attbi_s52...
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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Terry wrote:
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