Icons on buttons

  • Thread starter Christopher Anderson
  • Start date
C

Christopher Anderson

I have created a button in one of my toolbars to run one of my macros. I
would like to change the icon on the button (currently it is a smiley face).
How do I do that?

Chris
 
B

Bob Phillips

Christopher,

If you go into View>Toolbars>Customize, and right-click on a button that you
like, you can copy the image. Then right-click your smiley, and paste that
image.

Or you can right-click it, and select change button image and select from a
set of images there.

Or, you can set it with VBA to pick one of the built-ins. To get a utility
to see what FaceIds are available, visit John Walkenbach's site at
http://j-walk.com/ss/excel/tips/tip67.htm




--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

David McRitchie

OR make up your own image from any picture, and paste that.
It will be distorted to 16 x 16 bits.

OR copy a cell and paste that cell
suggest no more than 3 letters, change font color
and background to suit, probably center vertically and horizontally
with format, cells, alignment and then make cell square so you see what it
would look like then copy (ctrl+C) then use the
tools, customize, paste button image

see http://www.mvps.org/dmcritchie/excel/toolbars.htm
 
D

David McRitchie

Information overload <grin>
but I will (might) update my toolbars.htm page accordingly.
 
Top