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?

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?

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?

"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"
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?
|
| " 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?
|
|
|

Great information Jim. Thanks again.

"Jim Rech" wrote:

"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"
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?
|
| " 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?
|
|
|