Hi I need help on creating a custom face id that will show on any PC when
the workbook i am creating is opened. Can anyone help?

Many Thanks
Neil

There is an option in ToolsCustomize, and then right-click on the button,
and select edit button image. Crude but works. Other than that you need to
get an icon editor.

--

HTH

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


"Karoo News" wrote in message
...

Hi I need help on creating a custom face id that will show on any PC when
the workbook i am creating is opened. Can anyone help?

Many Thanks
Neil

Thanks for the reply. Once i've created the icon how do i add it to the
menu and ensure its saved in the workbook?



*** Sent via Developersdex http://www.developersdex.com ***

The way that I do it is to save the picture on a hidden worksheet, and in
the workbook open assign it


cbTable.Shapes(shapename).Copy*Picture
Application.Commandbars("myCB").Controls("myButton ").PasteFace

where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30'.



--

HTH

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


"Neil Atkinson" wrote in message
...
Thanks for the reply. Once i've created the icon how do i add it to the
menu and ensure its saved in the workbook?



*** Sent via Developersdex http://www.developersdex.com ***