I have an addin that creates a custom commandbar/toolbar for running macros. I have custom icons for each of them, unfortunately, they look horrible once they are loaded into the toolbar. The icons are saved in a worksheet names Icons. When the addin is loaded, the addin goes
I use...
And it takes in the picture 1 and puts it in the toolbar fine, BUT the colors are off and it doesn't look the same as the actual picture.
I've even gone as far as to use the icon editor in Excel, clean it up so that it looks like I want, Copy Button Image, Paste it back into the Icon worksheet and try to load the cleaned up version. But, they still look bad.
Any help is GREATLY appreciated!
Code:
.IsAddin = False
I use...
Code:
With .Controls.Add(type :=msoControlButton)
Sheets("Icons").Shapes("Picture 1").Copy
.Pasteface
And it takes in the picture 1 and puts it in the toolbar fine, BUT the colors are off and it doesn't look the same as the actual picture.
I've even gone as far as to use the icon editor in Excel, clean it up so that it looks like I want, Copy Button Image, Paste it back into the Icon worksheet and try to load the cleaned up version. But, they still look bad.
Any help is GREATLY appreciated!