Highlighting Boxes if a column width =0

[Jaywar2013]

Hi All

I have some simple Open/Close text macro buttons which reduce the column width to 0 when pressed, then when another is pressed it sets it to the desired width.

I have been asked if it is possible to highlight something to tell the user which are set to 0 (Highlighted Red) and which are set to the normal width (Highlighted green)

I would be good if it was the label text that changed colour in the text boxes if possible.

Your hopefully

Jay

 

[Jaywar2013]

Hi Rory

I got it to work

I just had to build it in two other macros.

I had two macro doing different things and it didnt work as a seperate macro with the active sheets, however once i built it into the other macros it works great.

Thank you for all you help my friend, a vertual beer is on its way to you.