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

Hi
in VBA have a look at the PasteFace method

--
Regards
Frank Kabel
Frankfurt, Germany
"Christopher Anderson"
schrieb im Newsbeitrag
...
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 ViewToolbarsCustomize, 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)


"Christopher Anderson" wrote
in message ...
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

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote in message ...
Christopher,

If you go into ViewToolbarsCustomize, 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)


"Christopher Anderson" wrote
in message ...
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

Hmm...MacXL v.X/2004 has 20 x 20 native images.

In article ,
"David McRitchie" wrote:

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

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

"JE McGimpsey" wrote ...
Hmm...MacXL v.X/2004 has 20 x 20 native images.

In article ,
"David McRitchie" wrote:

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