Missing "Custom View" entry from View menu

[mycroft777]

Hello

Can anyone help me with this problem

I'm using Excel 97 and the "Custom View" entry on the View menu bar ha
disappeared from the list

I've tried right clicking on the menu bar and choosing customize bu
all I can find is an option to add a drop down box to choose fro
existing views - I can't find an option to add a new view

Any ideas on how I can get it back without unistalling Excel
or deleting my Personal.xls file as I have a lot of macros I don't wan
to loose

Thank

 

[Dave Peterson]

The toolbar changes are stored in a file called *.xlb (name and location vary
with versions of excel and versions of windows). Reinstalling excel won't
help/hurt in this case. (And personal.xls won't be affected by a reinstall,
either.

Tools|customize|Commands tab|view category
Click on the custom view icon and drag it to the View toolbar.

If you ever want to reset the toolbars back to factory defaults....

close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)

Rename all the *.xlb files you find to *.xlbOLD (or just delete them if you
really want)