lost toolbar

M

mcunis

I have lost my toolbar in excel. I have tried the help
(XL2000) with the renaming of excel.xlb but it did not
work. what should I do now?
thanks
 
D

Dave Peterson

Was it a builtin toolbar?

If yes, then when you renamed the excel.xlb file, then excel will start fresh.

If it was a customized toolbar, how was it created--by a macro or was it a
toolbar you attached to a workbook? Or did you just create it manually?

In either of those first two cases, you should be able to rerun the macro or
open the workbook with the attached toolbar.

If it was a customized toolbar that you built by hand, then you may have to
recreate that.

===
I'm guessing that it was a builtin toolbar and you renamed some of the *.xlb
files, but not the one that excel was really using.

Try Windows Start Button|Find|and search your pc for *.xlb (remember to search
through hidden folders for hidden files, too.)

Then rename them and restart excel and see what happens.

===
Tools|customize|Toolbars tab
selecting the offending toolbar
Clicking reset maybe less destructive next 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

Top