Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Toolbars | Excel Worksheet Functions | |||
Custom Toolbars..? | Excel Discussion (Misc queries) | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
Custom toolbars | Excel Discussion (Misc queries) | |||
Custom ToolBars | Excel Programming |