Macro Button
 

Is there a way to make a button on the tool bar to allow a certain macro
to run? If so how?


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=520370

Macro Button
 

parteegolfer Wrote:
Is there a way to make a button on the tool bar to allow a certain macro
to run? If so how?
make your macro first,
right click on the grey are of the tool bars
Select Customize
Select commands =macro
grab and drag the button to a toolbar
right click on your new button and customize it, while you are there
you can assign your macro to it
close the customize window


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520370

Macro Button
 

Can I make a new tool bar to put it into?


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=520370

Macro Button
 

of course, same way, but go to toolbars=new and then figure it out from
there...


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520370