Custom Toolbars

[blackfish]

I am trying to write VB code to make custom toolbars and have been
somewhat successful. Is there a way to view the changes you have made
to the custom toolbar without having to save, close and restart the
file?

 

[Doug Glancy]

blackfish,

I'm not sure how you are making your toolbars, but a common approach is to
delete the toolbar before you create it. If you do this then you should be
able to just run the toolbar making subroutine, like this:

Sub test()
Dim cbar As CommandBarPopup

On Error Resume Next
CommandBars("Worksheet Menu Bar").Controls("test").Delete
On Error GoTo 0

Set cbar = CommandBars("Worksheet Menu
Bar").Controls.Add(Type:=msoControlPopup, temporary:=True)
cbar.Caption = "test"
End Sub

hth,

Doug