Rather than re-setting all Toolbars individually...........

Toolbar and Menu customizations and changes are stored in a file named
Excel9.XLB for 2000 version.

Do a file search for it.

Usually stored in

C:\Documents and Settings\User\Application Data\Microsoft\Excel

With Excel closed rename Excel9.xlb to Excel9.old

Re-start Excel and you will get factory defaults.


Gord Dibben Excel MVP


On 24 Mar 2005 13:03:26 -0800, wrote:


I messed up my toolbars in Excel 2000. How can I reset them to the
factory defaults? I'm not talking about going to Tools/Customize and
resetting each toolbar. That doesn't tell me which toolbars ARE the
defaults. Isn't there a way to put everything back without reinstalling
Office 2000?

Thanks!