why doesn't this caption property work

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Dim objCmdBar As CommandBarControl

Set objCmdBar = Application.CommandBars("Worksheet Menu
Bar").Controls.Add(Type:=msoControlButton, before:=9)

objCmdBar.Visible = True
objCmdBar.Caption = "Test"

It just produces blank menuitems

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel 2007 with Excel 2003 template 1
Nested Sub Menus 3
Excel 2013 menubar incompatibility? 1
CommandBar and Controls (how to create separate "Sets" of Controls) 4
Help with code please 2
Custom Menus and OnAction 4
Add menu item to right-click menu 1
Command Bars 3

Back
Top