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 |
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 |
All times are GMT +1. The time now is 07:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com