Macro Button??

[Michael Kintner]

I am having problem with assigning a macro to a button.

Is there a macro button?

or

When I add a VB button for the Excel Sheet I can not get it to run. How do
I do this?

Thanks in advance for any help.

Thanks,
Mike

 

[Bob Phillips]

Mile,

Go into Tools>Customize

Then right-click on the button, and you will see an option to Assign a macro
at the bottom of the menu.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Chip Pearson]

Michael,

If you use the button from the Forms command bar, just
right-click the button and choose "Assign Macro". If you use the
button from the Controls command bar, right-click the button and
choose "View Code" and call your macro from the Click event for
the button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com