Some macro help with formatting object please

  • Thread starter Thread starter Alan
  • Start date Start date
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!
 
activesheet.textbox1.backcolor=&h0000ff


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
PLEASE HELP ME 1
no worksheets in a workbook - Excel 2003 1
Excel display Fault 5
Writing Formula For conditional Formatting Using Excel 2000 3
Macro NOT completing 4
problem with macros and protections 5
Please Help with Macro Code 1

Back
Top