When I write a macro, how can I put an icon in the tool bar and change the looks of the icon?
L Lady Success Nov 12, 2006 #1 When I write a macro, how can I put an icon in the tool bar and change the looks of the icon?
G Gord Dibben Nov 12, 2006 #2 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
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
