Menu bar changes 1

[BusMgr]

I am an Excel newbie, I normally work in Access and Word. I assume that Excel cannot be that different, but.....

I've inherited an Excel app with modifications to the Worksheet Menu Bar. They have added a new control, with a name that no longer fits. ( File TXX Edit View etc.)

I need to change the name from TXX to DRT.

I've tried View, Toolbars, Customize. Then right click on the menu item, change the TXX to DRT and save, but each time I close the file and reopen it, the menu is back to TXX.

I've also tried the reset on the Reset option with no success.

Any help would be appreciated.

Thanks in advance.

BusMgr

 

[luceze]

Make sure that there is no code running on startup. The author might be recreating the menus when the workbook is opened.

HTH,
Eric

 

[BusMgr]

I've tried to follow the VBA code through like Access (form Open) but I do not see anything that indicates as you state above, that the menu is being recreated when you start up.

I'll shut off the has module (if that is an option) and try that.

Is there certain syntax in Excel that indicates on file open?

Thanks

Karl
aka BusMgr

 

[luceze]

If you go into the VB editor, you'll see the project explorer. Select this workbook. If there is any code in the on open event it would look like this.

Private Sub Workbook_Open()

End Sub

Also, check to see if there is anything in your xlStart folder.

Eric

 

[combo]

It is possible that the file was created under excel 5 or 95 - it has menu editor, you could add menu to the file in that way that it was shown and removed with file with no code.
In this case you can try with:
1. add empty sheet to the file
2. set workbook window to normal, so that you can see excel desktop
3. select all sheets except of added one and drag them onto excel desktop. You should get a new workbook with the same sheets as original. The project with menu should stay with empty single sheet.
4. save new workbook, delete menu item.

If this is the case, the above don't work and the menu item is still visible, you can try to open workbook under old version of excel (95), go to menu editor and remove menu from the file. It can be also removed programmatically. Menu, MenuItem still exist as hidden excel interface, but there is no help in help files.

combo

 

[BusMgr]

Combo

Thanks.

Got new workbook with menu item not there. Now I can rebuild it.

BusMgr