Custom Toolbars
 

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
------------------------------------------------------------------------
blackfish's Profile: http://www.excelforum.com/member.php...o&userid=29880
View this thread: http://www.excelforum.com/showthread...hreadid=495839

Custom Toolbars
 

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

"blackfish" wrote
in message ...

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
------------------------------------------------------------------------
blackfish's Profile:
http://www.excelforum.com/member.php...o&userid=29880
View this thread: http://www.excelforum.com/showthread...hreadid=495839