Attaching a macro to a button that sits on the worksheet whe

[Mel C Roberts]

I need to attach a macro that i have built onto a specific page in the spreadsheet. I believe this can be done using a button and attaching the macro to the button but can't work out how to do it. I do not want the macro to sit on the toolbar.

Can anyone help?

 

[SamS]

try View, Toolbars, Forms then depress the button icon and on your spreadsheet drag a button to the size you want. Excel will lead you through the process of assigning the macro. Any time you want to edit the button right click on it first otherwise you will invoke the macro.