Macro Button

[stephenp12]

Hi, I have created a macro and I want to create a button that sits on the worksheet that prompts the user to click the button to run the macro once he/she has made some changes to the assumptions. Thanks Stephen.

[dominicb]

Good afternoon stephenp12

Go to Developer > Controls > Insert and choose the button under Form Controls. Draw the button and choose which macro to assign it to.

If you don't have the developer tab, go to the Office button, Excel Options and tick the box under Popular that says "Show the Developer tab in the ribbon" and Hey Presto ... !

HTH

DominicB