How To Keep Worksheet_Change From Firing?
Per Jim Thomlinson:
To turn them back on again. It is VERY importtant that you remeber to turn
them back on as this is a persistent application level setting. If you forget
to turn them bakc on then then no events will fire in Excel (until you run
code to turn the events back on).
But only in the context of the currently-running instance of
Excel, right?
i.e. even if the code fails to turn it back on, once they close
the spreadsheet, exit from Excel, and then open some other sheet
they'll be ok...
--
PeteCresswell
|