Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
When a menubar is added, it is added to the Excel application, so you must delete it from there too. I'm assuming your menubar is on the main Excel menubar. Add something like this to the top of the code that installs the new menubar Set cbWSMenuBar = CommandBars("Worksheet Menu Bar") An old menubar may still exist. So delete it just in case On Error Resume Next cbWSMenuBar.Controls("myOldMenu").Delete On Error GoTo 0 of course, "myOldMenu" may be the same name as your new menu. You should put these lines at the top of any code which adds a menubar, as an improper Excel shutdown might leave the menubar there and the next time you add the menu bar you will have two of them. regards Paul On Mar 27, 2:37*pm, Len Excel Manic Porzio <Len Excel Manic wrote: In Excel 2003 we "attached" a custom toolbar menu to a spreadsheet and saved it locally which persists properly. *However, if we copy the file to removable media and move it to another machine, we see an old version of the menu rather than the most recent menu additions. *We have erased all files and tried saving directly from Excel as well as dragging and droping the file but nothing seems to help. How can we fix this? *Is there a work around? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding custom images to a button on custom toolbar | Excel Programming | |||
Custom face for custom toolbar item | Excel Programming | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |