#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 28
Default Macro Button

When I write a macro, how can I put an icon in the tool bar and change the
looks of the icon?
--
Lady
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Macro Button

ToolsCustomizeCommands.

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

On Sun, 12 Nov 2006 10:23:01 -0800, Lady Success
wrote:

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign a macro to a command button SheriTingle Excel Discussion (Misc queries) 4 September 25th 06 06:38 PM
Assigning a macro to a command button SheriTingle Excel Discussion (Misc queries) 1 September 25th 06 06:34 PM
Creating a macro that simulates some of the toolbar button Duangruthai New Users to Excel 1 April 22nd 06 12:12 AM
Custom Toolbar Button No Longer Runs Assigned Macro Bryan Excel Discussion (Misc queries) 1 April 10th 06 06:02 PM
Button not bring up Macro I created A.S. Excel Discussion (Misc queries) 1 July 22nd 05 10:21 PM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"