Adding a button to a spreadsheet that runs a macro

D

doc

I would like to add a button to a spreadsheet that runs a macro. I have
completely forgotten how...brain dead!!! I'm up in the arctic circle
without any reference books and "Help" isn't doing it for me.
 
D

Dan E

Doc,

Add a button from the Forms menu (View -> Toolbars -> Forms)
If it doesn't automatically pop up the dialog Right click the button
and choose Assign Macro.

Dan E
 
J

justin

-----Original Message-----
I would like to add a button to a spreadsheet that runs a macro. I have
completely forgotten how...brain dead!!! I'm up in the arctic circle
without any reference books and "Help" isn't doing it for me.



------------------------------------------------
[/url]
~~ View and post usenet messages directly from http://www.ExcelForum.com/

.
Click to expand...
Set up the macro
View the Forms Toolbar (View - Toolbars)
Left click the Button control on the toolbar and create a
button on the worksheet. It will prompt you for the macro
name to run.
 
Top