Some macro help with formatting object please

A

Alan

I have a macro that turns on the calculate command function while the
user works in it. I was asked if I could have the color of the text box
that launches the macro turned RED when the calculate feature has been
turned off. Is that possible?

TIA!
 
B

Bob Phillips

activesheet.textbox1.backcolor=&h0000ff


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top