Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I created a macro command. Then I want to add a button on the tool bar
to run the macro. When I added the button to the tool bar there was only a smiley face button available. How do I change the button image to something else that is appropriate to the function of the macro? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Tools|Customize (just to have that dialog showing)
Rightclick on your icon Select change button image and choose the one you want. " wrote: I created a macro command. Then I want to add a button on the tool bar to run the macro. When I added the button to the tool bar there was only a smiley face button available. How do I change the button image to something else that is appropriate to the function of the macro? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the reply; however, it does not work. Right click does not
prompt options to change icon. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Did you show that tools|customize dialog?
" wrote: Thanks for the reply; however, it does not work. Right click does not prompt options to change icon. -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes it does, make sure you are in customize "mode"
You will get a dropdown with lots of choices, change button image will give you a whole palette of icons to choose from -- Regards, Peo Sjoblom wrote in message oups.com... Thanks for the reply; however, it does not work. Right click does not prompt options to change icon. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
That is it, Customize then right click on the icon and select Change
Button Image - and select from the group of available icons. Thanks for the replies and the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Button to change borders | Excel Discussion (Misc queries) | |||
Undo Button Click change | Excel Discussion (Misc queries) | |||
how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
Change caption on a macro button | Excel Worksheet Functions | |||
Macro button colour change??? | Excel Worksheet Functions |