How do I restore the default settings in Excel 2003?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MorAnco - 27 Jun 2006 13:10 GMT

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.

Reply to this Message

Gord Dibben - 27 Jun 2006 18:10 GMT

With Excel closed.

Search for your Excel11.XLB file

Rename it Excel11.OLD

Re-start Excel

Any joy?

Gord Dibben MS Excel MVP

>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.

Reply to this Message

MorAnco - 28 Jun 2006 06:57 GMT

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.

> 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.

Reply to this Message