Excel: Highlighting Boxes if a column width =0

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 :confused:

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of October 07, 2013.

For more resources for Microsoft Excel