Customised Menu's

[Preet]

Hi

I wonder whether anyone can help!!

Basically one of my users, has a problem with a customised menu, in xl.
Basically he has 2 seperate excel spreadsheets, each having their own
customised menu's. When he opens one of them, the wrong customised menu
appears, (rather it gives the customised menu of another spreadsheet),
the other spreadsheet im referring to has not been opened.

Yet atill the user gets the menu bar of a different spreadsheet, I have
already been though all the Tools > Customise > Options aswell as
Toolbars, to check the right items are ticked, and a reset of usage
done, but nothing seems to work. I REALLY DONT UNDERSTAND WHY.

Any idea, sorry if this has confused you, I guess im nit explaining it
correctly.

Thank you.

 

[Dave Peterson]

Customized menus can be created in a few different ways.

You could modify them manually (tools|customize). These'll be stored in a file
called *.xlb. (The name and location will vary with versions of excel and
windows, but they all have .xlb as the extension.)

Another way is to build them on the fly. You could have a macro add things to
the menubar when the workbook is opened and clean up after itself when the
workbook is closed.

And one more way is to attach a toolbar to the workbook. These toolbars follow
the workbook around. But they can be tricky to update when something changes.

Jan Karel Pieterse has posted some nice instructions for attached toolbars:
http://google.com/[email protected]

If none of this shed any light, you may want to post back with more details--how
the toolbars were created, version of excel, etc.