FIFARay007
Board Regular
- Joined
- Jan 7, 2008
- Messages
- 111
I have some code that adds a custom commandbar to Excel, and have been able to add a few buttons to it. How can I add a separator between 2 of them?
sample from my code...
sample from my code...
Code:
Set Mycbar = CommandBars.Add(Name:="EssMenu", Position:=msoBarTop, Temporary:=False)
Set Mycontrol = Mycbar.Controls.Add(msoControlButton)
With Mycontrol
.Caption = "Essbase Login"
.Tag = "Login"
.OnAction = "Connect"
.FaceId = 277
End With
Set Mycontrol = Mycbar.Controls.Add(msoControlButton)
With Mycontrol
.Caption = "Retrieve"
.Tag = "Retrieve"
.OnAction = "Retrieve"
.FaceId = 317
End With