I know you can make a key shortcut for a macro but is there anyway to put a shortcut to fun a macro on the tool bar of excel?
I know you can make a key shortcut for a macro but is there anyway to put a shortcut to fun a macro on the tool bar of excel?
Right Click on Toolbar
Select Custimize
Select Commands Tab
Under Categories Select Macro
Left Click on displayed Custom Button, Whilst holding down left mouse button Drag & Drop Icon onto Toolbar
Right Click on the newly added Toolbar Icon - this will give you options for changing Button Image. Assign Macro etc.
To change details in the future follow these instructions
Right Click on Toolbar
Select Custimize
Select Commands Tab
Under Categories Select Macro
Right Click on the Toolbar Icon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks