Custom Macro Tool Bar Button

keepitfrozen

New Member
Joined
Nov 30, 2005
Messages
40
I've created some simple macro's to format some of my reports but I would love to create a custom menu and assign a shortcut to each macro for each access to the macro.

I'm not sure if this is an easy thing to accomplish for a rookie like me.

thanks,

Mark
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Mark

Go tools, customise, toolbars, new, enter a name and add. You can then customise this new toolbar by right clicking, commands, macros, custom button and drag the button onto the new toolbar. Right click the button and this gives you the option to change the icon, and amongst other things assign a macro.

HTH

Tony
 

Watch MrExcel Video

Forum statistics

Threads
1,118,020
Messages
5,569,678
Members
412,287
Latest member
Ardamit
Top