View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 2
Default why doesn't this caption property work

Dim objCmdBar As CommandBarControl

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

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

It just produces blank menuitems

Thanks