How do I restore the default settings in Excel 2003?

M

MorAnco

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

Gord Dibben

With Excel closed.

Search for your Excel11.XLB file

Rename it Excel11.OLD

Re-start Excel

Any joy?


Gord Dibben MS Excel MVP
 
M

MorAnco

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and excel 0
How do I set focus (and select text) on a text box on a modeless userform? 0
New computer, how do i move outlook 365 ENTIRELY? 0
set Excel 2007 as default to save files in Excel 2003 .xls format 1
VBA - exporting serial letters to single documents 0
How to create portable Excel applications? 2
how do I save/backup my settings? 1
How do I Set XLS to default to Excel 2003 1

Top