Andy Pope's button image editor; pasting icons to sheet then toolbar- why does image quality degrade?
 

I used Andy Pope's add-in to save my custom button icons as .bmp files.

To use them in my add-in, instead of trying to load them from the .bmp files
directly, I used insert/image to put each .bmp on a worksheet in my add-in.
I then use code to paste them to my new toolbar.

The problem is that I seem to have quality problems in (at least) two
places; when I insert a .bmp and enlarge it for analysis, the picture is
similar to the original, but blurry (I'd expect it to just show a large
16x16 block of colors). Then when I paste it to the toolbar- then copy that
image back into Andy Pope's editor, the end result shows that the image had
further degraded.

I'd like a clean (and transparent) .bmp on my final toolbar, but many google
searches have turned up nothing.

Is there a preferred approach to ensure that the button image quality
remains stable/clean all the way through to the final toolbar?

Thanks!
Keith

Andy Pope's button image editor; pasting icons to sheet then toolbar- why does image quality degrade?
 

After many google searches, I quit searching with words like 'Excel VBA
custom toolbar icon fuzzy blurry quality' and used just "pasteface". I found
Jon Peltier's excellent suggestion here, and now I have clean icons.

http://www.eggheadcafe.com/forumarch...st23958841.asp

This response posted to close out the thread and archive the solution for
future searchers.

Thanks,
Keith


"ker_01" wrote in message
...
I used Andy Pope's add-in to save my custom button icons as .bmp files.

To use them in my add-in, instead of trying to load them from the .bmp
files directly, I used insert/image to put each .bmp on a worksheet in my
add-in. I then use code to paste them to my new toolbar.

The problem is that I seem to have quality problems in (at least) two
places; when I insert a .bmp and enlarge it for analysis, the picture is
similar to the original, but blurry (I'd expect it to just show a large
16x16 block of colors). Then when I paste it to the toolbar- then copy
that image back into Andy Pope's editor, the end result shows that the
image had further degraded.

I'd like a clean (and transparent) .bmp on my final toolbar, but many
google searches have turned up nothing.

Is there a preferred approach to ensure that the button image quality
remains stable/clean all the way through to the final toolbar?

Thanks!
Keith