Excel 97 menu items

O

Oldjay

Can you edit names of the menu bar pull down items that were made in Excel 97
in Excel 2003?
 
D

Dave Peterson

Maybe...

Try
Tools|Customize
Rightclick on the name you want to change and change the Name.

But if you're creating the toolbar in code, I would think it would be better to
just change the code to use the name you want.
 
O

Oldjay

When I do what you suggested all of the pull down items are grayed out.
The items are assigned to a macro I can change the inside the Macro to do
what I want but that doesn't change the pull down name (which is different
than the macro name).
 
D

Dave Peterson

How was the toolbar built?

If it was in code, then there's an option to prohibit changes to the toolbar.
But then you could just change the name in the code.
 
G

Gord Dibben

You sure these were created in Excel 97?

Maybe you saved an older original Excel 95 workbook where the menu items were
created by the Menu Editor.

If this is the case, you cannot get rid of them without some code.

Jim Rech provides an addin named RemoveMenus which will get rid of them.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP
 
Top