Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created a custom toolbar that is Attached to a particular workbook
file. Every time I open that file, the custom toolbar appears as it is supposed to. However, none of the toolbar buttons that I put on the toolbar appear with it, even though I saved the workbook after I put the buttons one during the last session. I do have some code that deletes the custom toolbar from the workbook when the workbook closes so the toolbar is only open when that file is open, but I wouldn't expect this to have any effect on whether the toolbar buttons remain on the toolbar. On the outside chance this is causing my problem, here's the code I'm using for that purpose: *************** Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume Next Application.CommandBars("TimesheetToCalStars").Del ete End Sub Sub Auto_Close() On Error Resume Next Application.CommandBars("TimesheetToCalStars").Del ete End Sub *************** What can I do to get these toolbar buttons to remain on the toolbar the next time I open the workbook? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 Custom toolbar problem saving new buttons | Excel Discussion (Misc queries) | |||
Buttons in a toolbar | Excel Discussion (Misc queries) | |||
custom toolbar looses buttons when closed | Setting up and Configuration of Excel | |||
Toolbar buttons | Excel Discussion (Misc queries) | |||
How can I keep Toolbar Buttons on the toolbar? | Setting up and Configuration of Excel |