Macro Button??

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

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
 
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)
 
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
 
Back
Top