Toggle Code to format-unformat range of cells

[Zimbo]

Hi All,

I am trying to combine the 2 macro strings below.
This is to change the font colour in a range of cells so as to hide the inputs and then unhide them when toggle button is unclicked.

Any recommendations on a shorter line of code would be much appreciated.

Thanks

Please Login or Register  to view this content.

[mikerickson]

This should do it

Please Login or Register  to view this content.

I was getting errors trying to set the .ColorIndex to xlNone, so I used 2 (white).

If there were more properties to be toggled, an If Else EndIf would be a good way to go.

[Zimbo]

Hi Mike,

That works a treat.

Thanks so much for your help.

Cheers