Hi,

There are probably more elegant solutions, but for a quick fix, cant
you use some module level globals to selectively set/unset and then
execute the code within the macros based on the true/false of those
booleans?

Best Regards,
-feltra


On Jan 9, 9:56 pm, Gator wrote:
I want to be able to turn the macro on and off. When I enable the macro, the
formatting works and continues to work - which is what I want it to do. I
want to be able use another icon that disables the macro and clears the
formatting, without having to remove it or closing the sheet, because I might
want to turn it back on. It's like, for the same sheet, sometimes I want it
and sometimes I don't - which could be several times in a day or in an hour.