Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom faces for custom menus/commandbars
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom faces for custom menus/commandbars
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/ _______ Stu Valentine wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help Me with Custom menus | Excel Worksheet Functions | |||
custom menus | Excel Programming | |||
Question on custom commandbars | Excel Programming | |||
Custom menus | Excel Programming | |||
Custom Menus | Excel Programming |