Adding a button to a spreadsheet that runs a macro

  • Thread starter Thread starter doc
  • Start date Start date
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.
 
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
 
-----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.



------------------------------------------------

~~ 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.
 
Back
Top