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