Command button to toggle worksheet event code on / off?
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Fred
Be very careful with that toggle on/off code I posted.
Could leave you with events disabled when you don't want them disabled if
you
forget to turn back on.
I was hoping someone would help us with a method to just disable for that
worksheet.
Thanks for everyone's replies.
Particular thanks to Gord for posting the original code - despite my lack of
knowledge on this subject, all warnings are duly heeded :-)
I am using the technique to learn a little more about coding, and the
ability to highlight edited cells in a large worksheet appealed as a
worthwhile project that would certainly be better than my present method of
tracking multiple changes!
Mike, Thanks but my problem is that the toggle code is not, as I understand
things, a "macro" and my newfound attempts to uses that method did not
work - I don't know the correct terminology.
JL, Yes I am currently using your method but I was hoping to be able to use
a button because my large worksheet already uses the top three rows for
titles. And yes, I have discovered that the command button does respond to
multiple clicks.
Gord, I deliberately posted this as a new question in the hope that somebody
would suggest "another way" rather than the usual "one way"!
Thanks again.
--
Fred
|