Icons on buttons

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

Guest

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
 
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)
 
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
 
Information overload <grin>
but I will (might) update my toolbars.htm page accordingly.
 

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

How to remove customized button from toolbar? 1
How to assign macro coding into customized button? 4
Remove/Re-assign Smiley Face Macro? 1
Macro button on toolbar 2
Custom buttons 2
change tool bar button image 5
inserting an autoshape into a chart 9
Where can I get more toolbar icons? 3

Back
Top