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

Mel C Roberts · Apr 23rd, 2002, 05:31 AM

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 · Apr 23rd, 2002, 05:39 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 05:31 AM	#1
Mel C Roberts New Member Join Date: Feb 2002 Location: England Posts: 40	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?

Apr 23rd, 2002, 05:39 AM	#2
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	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.