activate/deactivate macros

**cinciman22** · 09-17-2009, 02:01 PM

I am wondering how to add a button on my custom toolbar to activate a macro and then I also want to be able to click the button again and deactivate the macro.

The specific macro I want to activate and deactivate highlights the entire row and column so you can see it better. I want to be able to turn it on and off easily with a button click.

Is it also possible to add a keyboard shortcut to activate/deactivate it?

thanks,
john

**royUK** · 09-17-2009, 02:22 PM

Post your code

**cinciman22** · 09-17-2009, 02:30 PM

this is code i want to activate/deactivate with a button and shortcut key:

Please Login or Register  to view this content.

and this is other code already in my toolbar:

Please Login or Register  to view this content.

thanks

**JBeaucaire** · 09-17-2009, 02:55 PM

Your know how to do the coding, so the turn on/off thing can be simple if you create cell value somewhere to check, or store a value in a public variable.

In the sheet module:

Please Login or Register  to view this content.

And in a regular module:

Please Login or Register  to view this content.

Just attach that DoIt() module to a macro button to turn it off/on.

Or, as an alternate, you could store a DoIt variable as "Boolean" and just check the status of that public variable as whether the activity should be occurring or not.