Thread: Macro Button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
davesexcel[_47_] davesexcel[_47_] is offline
external usenet poster
 
Posts: 1
Default 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