Picture

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

Hi All

I have a workbook where I have added a toolbar. Now on
that toolbar I have used the standard numbered pictures,
such as picture number 52 is a piggy bank. I was
wondering if anyone know weather it is possible to import
these button pictures as actual pictures into my program?

Thanks
Jase
 
The won't be very big.

go to tools=>Customize

leave the dialog up and select one of the buttons on the menus, then right
click on it and select copy picture

close the dialog and then select the worksheet, do edit=>Paste

If you mean bring a picture in to use, reverse this. Get the image in the
clipboard, then tools=>customize, then right click on a button with the
dialog still visible and select paste picture.

In code do this with copyface and pasteface.
 
Thanks heaps for that Tom, I have managed to get this
into an Excel spreadsheet as images, but is it going to be
possible to move them onto a user form?

Thanks in advance
Jase
 
Back
Top