"Attaching" toolbars does not work very well and that's why "pros" don't do
it. Rather they use code to create the toolbars on the fly.
One problem is that a toolbar attached to a workbook become a permanent part
of the Excel application. It's still there the next time you use Excel even
if the workbook with it attached is not opened. And furthermore, if Excel
already has a toolbar with the name "xxx" it takes precedence over one
attached to a workbook with the same name. So when you open a workbook with
an updated toolbar you still see the old toolbar.
So, when you want to update a toolbar, you must use View, Toolbars,
Customize, Toolbars to delete the current toolbar before you open the
workbook with the updated toolbar.
--
Jim
"Len Excel Manic Porzio" <
[email protected]>
wrote in message | 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?
|
| "(e-mail address removed)" 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
| > (e-mail address removed)> 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?
| > > (e-mail address removed)
| >
| >
