View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Fred[_2_] Fred[_2_] is offline
external usenet poster
 
Posts: 9
Default 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