If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Missing "Custom View" entry from View menu
Hello Can anyone help me with this problem I'm using Excel 97 and the "Custom View" entry on the View menu bar has disappeared from the list I've tried right clicking on the menu bar and choosing customize but all I can find is an option to add a drop down box to choose from 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 want to loose Thanks -- mycroft777 ------------------------------------------------------------------------ mycroft777's Profile: http://www.excelforum.com/member.php...o&userid=31141 View this thread: http://www.excelforum.com/showthread...hreadid=508021 |
#2
|
|||
|
|||
Missing "Custom View" entry from View menu
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) mycroft777 wrote: Hello Can anyone help me with this problem I'm using Excel 97 and the "Custom View" entry on the View menu bar has disappeared from the list I've tried right clicking on the menu bar and choosing customize but all I can find is an option to add a drop down box to choose from 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 want to loose Thanks -- mycroft777 ------------------------------------------------------------------------ mycroft777's Profile: http://www.excelforum.com/member.php...o&userid=31141 View this thread: http://www.excelforum.com/showthread...hreadid=508021 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do i get data view or data entry view | bisigreat | General Discussion | 0 | January 26th, 2006 08:18 PM |
Drop down menu View missing, how do I restore? | Lost | General Discussion | 1 | October 27th, 2005 04:05 PM |
Access 2003 - Missing Menu Bar | Juliet Alpha | General Discussion | 4 | June 13th, 2005 01:30 AM |
Tools on Menu Bar is Missing | Denise | New Users | 1 | May 4th, 2005 03:22 PM |
"TOOLS" menu missing from menu bar | Anil Gupta | Publisher | 0 | January 17th, 2005 04:57 PM |