Toolbar customized

[ItalyFrom]

How to customize the toolbar adding a particular picture for each botton.
Thanks.
Regards.

 

[VBAjedi]

We'll need some more detail to really be able to help you. Are you referring to a custom toolbar that you created using VBA? Or are you referring to a predefined toolbar?

Are you wanting to put one of the icons provided by Microsoft onto each button, or are you wanting to use actual pictures/graphics of your own design?

Putting an icon onto a custom toolbar button is pretty easy, if that's what you want to do. You need to know the icon's number (there's over 1000 of them), but there's tools available off the internet to browse these icons to find the number for the one you like. Once you know the icon number, you can just use code like:

MyCustButton.FaceId = 596

where MyCustButton is a Commandbar button object that you have created using code like:

Set MyCustButton = CustBar.Controls.Add(Type:=msoControlButton)

VBAjedi

 

[ItalyFrom]

I'm referring to standard excel toolbar in the view menu.
I create a simple tool with excel & VBA and now I want improve it with a customized botton in one toolbar. But I can't add my icon only one of standard set of icons.
I wish you a very beatiful Christmas and new year.
Thanks.
Regards.