Group:  Microsoft Excel ยป microsoft.public.excel.setup
Thread: How do I restore the default settings in Excel 2003?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How do I restore the default settings in Excel 2003?
MorAnco 27.06.2006 12:10:02
I have used VBA to alter the user interface in Excel 2003. In the process
Excel crashed and has left remnants of the VBA generated interface. I wish
to get back to Excel default settings without having to reinstall Excel. I
have tried all the normal methods outlined in Excel 2003 help to no avail.

Thanks.
Re: How do I restore the default settings in Excel 2003?
Gord Dibben <gorddibbATshawDOTca> 27.06.2006 17:10:13
With Excel closed.

Search for your Excel11.XLB file

Rename it Excel11.OLD

Re-start Excel

Any joy?


Gord Dibben MS Excel MVP

On Tue, 27 Jun 2006 05:10:02 -0700, MorAnco <MorAnco[ at ]discussions.microsoft.com>
wrote:

[Quoted Text]
>I have used VBA to alter the user interface in Excel 2003. In the process
>Excel crashed and has left remnants of the VBA generated interface. I wish
>to get back to Excel default settings without having to reinstall Excel. I
>have tried all the normal methods outlined in Excel 2003 help to no avail.
>
>Thanks.

RE: How do I restore the default settings in Excel 2003?
MorAnco 28.06.2006 05:57:01
Thank you for your input but unfortunately, the search did not locate the
file Excel11.xlb. However, I did find another way around the problem by
using Detect and Repair... in the Help menu. This restored my default
settings without any pain.
Many thanks again for your time.

"MorAnco" wrote:

[Quoted Text]
> I have used VBA to alter the user interface in Excel 2003. In the process
> Excel crashed and has left remnants of the VBA generated interface. I wish
> to get back to Excel default settings without having to reinstall Excel. I
> have tried all the normal methods outlined in Excel 2003 help to no avail.
>
> Thanks.

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net