Custom Toolbars

  • Thread starter Thread starter blackfish
  • Start date Start date
B

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?
 
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
 
Back
Top