How to create a clickable button and macro in

Closed
Jeff - Apr 30, 2009 at 08:00 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - May 2, 2009 at 03:46 AM
Hello,

I am trying to create a button in an Excel worksheet that will continuously recalculate the formulas on a given sheet. I have seen a button in someone else's workbook that would display different text when the button was clicked (Update On/Update Off).

Any assistance with both creating the button and the macro for this would be greatly appreciated!

Thank you,
Jeff

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
May 2, 2009 at 03:46 AM
buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On")
17