View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Len Excel Manic Porzio[_2_] Len Excel Manic Porzio[_2_] is offline
external usenet poster
 
Posts: 2
Default Custom Toolbar Changes Not Portable

Thanks Paul. I will try something like this, however the menus were set up
manually so I'm surprised at Excel's behaviour.

Does it matter that this was a custom tool bar installed vertically along
the right side of the frame?

" wrote:

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?