label in Execl commanbar

[AtomicWedgie]

Hi,

is it possible to place a label in a Commandbar without it being attached to a CommandbarButton?

Greetz,

Atomic Wedgie

 

[broadthought]

You can use the tag property to attach information to the commandbar, and other controls.

e.g.

Application.CommandBars("Worksheet Menu Bar&quot.Tag = "my customized"

 

[RobBroekhuis]

I think you mean you want just text, not an icon, to appear on the toolbar. You can do that. For example, to add a caption-only "button" called "Hello" to the standard toolbar, you would use:

set nc=application.CommandBars(3).controls.add
nc.style=msoButtonCaption 'this is what you're looking for
nc.caption="Hello"

Rob