Custom faces for custom menus/commandbars

[Stu Valentine]

Hi all,

I know this has been a much raised Q, but i have a (i think) different
slant on it:

I have created a toolbar with my own custom images - i now want to use
these images for a menu and toolbar that will be created by an add-in
(rather than attaching the toolbar to the add-in).

I have been using J-Walk's "menumaker" code for this (*tips hat*),
adapted to allow the copy/pasting of the button face images.

The problem i am having is that when i copy the images to the
worksheet, and then paste them back again while creating the
menu/commandbar, the images do not appear as i originally designed
them, but fuzzy and with notable blurring/loss of clarity.

Why can i not EXACTLY reproduce/copy the orginal faces?

I am setting the relevant worksheet cells to 16x16 pixels, but this
only gets the size right - the blurring is still there.

Any help much appreciated!

Stuart

 

[Jon Peltier]

Hi Stu -

After a couple years of frustration, I finally realized my problem with
this. And let me tell you, it was a real Duh! moment.

Don't copy the picture prior to pasting. Use the CopyPicture method,
using the xlBitmap option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______