software

Hello

Can anyone help me with this problem

I'm using Excel 97 and the quot;Custom Viewquot; 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: www.excelforum.com/member.php...oamp;userid=31141
View this thread: www.excelforum.com/showthread...hreadid=508021The 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:
gt;
gt; Hello
gt;
gt; Can anyone help me with this problem
gt;
gt; I'm using Excel 97 and the quot;Custom Viewquot; entry on the View menu bar has
gt; disappeared from the list
gt;
gt; I've tried right clicking on the menu bar and choosing customize but
gt; all I can find is an option to add a drop down box to choose from
gt; existing views - I can't find an option to add a new view
gt;
gt; Any ideas on how I can get it back without unistalling Excel
gt; or deleting my Personal.xls file as I have a lot of macros I don't want
gt; to loose
gt;
gt; Thanks
gt;
gt; --
gt; mycroft777
gt; ------------------------------------------------------------------------
gt; mycroft777's Profile: www.excelforum.com/member.php...oamp;userid=31141
gt; View this thread: www.excelforum.com/showthread...hreadid=508021

--

Dave Peterson