Creating a macro button with VBA

Hi All,

I have a macro that is attached to a run button. when the macro is finished it will have created 15 tabs and done many calculations. I would like to have a reset button to return the workbook to it's original form. Although i would not like the user to be able to see the reset button until he/she has run the 'Run' button. I already have the reset code, i would just like the 'Run' macro to at the end create a button called 'Reset' that will show up on sheet1 and assign my reset code to it. Thanks for any help.

amotto11,

While that specific request is doable, it is much easier to have the button already created, but set its visible property to false. Then, at the end of your run button, make the reset button visible. At the end of the reset button code, make the reset button invisible again. Note that invisible buttons cannot be clicked.

Okay, that makes total sense, do you have any sample code to make a button visible or not?

Thanks

Please Login or Register  to view this content.

Thanks so much for the help!