Macro Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I write a macro, how can I put an icon in the tool bar and change the
looks of the icon?
 
Tools>Customize>Commands.

Scroll down to Macros.

Drag Custom Button to your Toolbar.

Right-click on the button and you have some options.

1. Name the button.
2. Assign macro.
3. Edit button image.
4. Change button image. You have a limited number of choices.

Download John Walkenbach's file Button Faces from here.

http://www.j-walk.com/ss/excel/files/developer.htm

Any of these can be dragged to your toolbar and have a macro assigned.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collapsing all groups 0
Macros Question 1
Customized marcos cannot save to tools-bar 1
Macro Security 1
Inserting cells (shift cells right) using macro 0
Macro Icon 1
Search Macro 3
Macro Question 2

Back
Top