H
Hans-Christian Francke
I tried the example from the VBA helpfile.
Dim myBar As CommandBar
Set myBar = CommandBars.Add(Name:="Custom", Position:=msoBarPopup,
Temporary:=False)
With myBar
.Controls.Add Type:=msoControlButton, ID:=3
.Controls.Add Type:=msoControlComboBox
End With
myBar.ShowPopup
However Commandbars is not recognized as an object even though Office 10.0
is referenced.
--
Thank for any help.
Kindest regards
HC Francke
Dim myBar As CommandBar
Set myBar = CommandBars.Add(Name:="Custom", Position:=msoBarPopup,
Temporary:=False)
With myBar
.Controls.Add Type:=msoControlButton, ID:=3
.Controls.Add Type:=msoControlComboBox
End With
myBar.ShowPopup
However Commandbars is not recognized as an object even though Office 10.0
is referenced.
--
Thank for any help.
Kindest regards
HC Francke