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

"blackfish" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>