Run a Macro from Toolbar

  • Thread starter Thread starter JHL
  • Start date Start date
J

JHL

After setting up a Excel macro, how can I place it as an
option in the Tools section of the toolbar?

Help is appreciated.
 
Manual you can do this

View>Toolbars...Customize
On the Commands Tab select Macros

Drag one of the buttons to the Tools menu and place it where you want
Right click on the button to assign the macro to it
 
JHL,

You said tools section, so I think you're wanting to put an item in the
Tools dropdown of the Menu bar, not a button in a toolbar. Go into
Customize (View - Toolbars - Customize). Use the Commands tab, select a
category (Macro) and a command (custom). Drag it to "tools" on the menu
bar, and when the dropdown opens, drag it where you want it. While still in
Customize, you can right-click it to change the button face, the text, and
assign it to your macro.
 
Back
Top