Lost my customized toolbars

[Danni2004]

Excel had its default toolbars when I opened a file this morning and my
customized toolbars were gone. There were many customized macro buttons I
created and assigned and it will take me hours to re-create these toolbars.
My Excel.XLB did not disappear and is still listed under C:\Documents and
Settings\<user name>\Application Data\Microsoft\Excel
Is there any way possible to restore my settings from yesterday when my
Excel worked fine?

Thank you for any advice!

[Gord Dibben]

First, rename the *.XLB file to *.OLD file. Note the size of this file in kb

Now close out Excel then re-open.

Make a few minor changes to a menu or toolbar then close Excel.

Does Excel create a new *.XLB file?

Is it basically the same size as the *.OLD file?

Your original customized *.XLB file could have already been overwritten "this
morning".

Have a search around to see if your customized *.XLB file exists in another
folder.


Gord Dibben MS Excel MVP

On Wed, 29 Mar 2006 13:52:03 -0800, Danni2004
<[email protected]> wrote:

>Excel had its default toolbars when I opened a file this morning and my
>customized toolbars were gone. There were many customized macro buttons I
>created and assigned and it will take me hours to re-create these toolbars.
>My Excel.XLB did not disappear and is still listed under C:\Documents and
>Settings\<user name>\Application Data\Microsoft\Excel
>Is there any way possible to restore my settings from yesterday when my
>Excel worked fine?
>
>Thank you for any advice!

[David McRitchie]

Hi Danni,
If you have not exited Excel yet then see
http://www.mvps.org/dmcritchie/excel....htm#emergency
once you have exited Excel it is too late for this method.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gord Dibben" <gorddibbATshawDOTca> wrote in message news:[email protected]...
> First, rename the *.XLB file to *.OLD file. Note the size of this file in kb
>
> Now close out Excel then re-open.
>
> Make a few minor changes to a menu or toolbar then close Excel.
>
> Does Excel create a new *.XLB file?
>
> Is it basically the same size as the *.OLD file?
>
> Your original customized *.XLB file could have already been overwritten "this
> morning".
>
> Have a search around to see if your customized *.XLB file exists in another
> folder.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 29 Mar 2006 13:52:03 -0800, Danni2004
> <[email protected]> wrote:
>
> >Excel had its default toolbars when I opened a file this morning and my
> >customized toolbars were gone. There were many customized macro buttons I
> >created and assigned and it will take me hours to re-create these toolbars.
> >My Excel.XLB did not disappear and is still listed under C:\Documents and
> >Settings\<user name>\Application Data\Microsoft\Excel
> >Is there any way possible to restore my settings from yesterday when my
> >Excel worked fine?
> >
> >Thank you for any advice!
>