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 ***