My toolbars revert to default

[Guest]

I customize my toolbars, but one day I open Excel and they have reverted to the default and I have to re-customize them. Any ideas on how to KEEP my toolbars?

 

[David McRitchie]

I have a page on tool bars
http://www.mvps.org/dmcritchie/excel/toolbars.htm
and a page on backups
http://www.mvps.org/dmcritchie/excel/backup.htm

Since your personal.xls workbook is likely to be your first workbook
opened, it would be best to create your toolbars with only that
workbook open and not hidden. When finished working on
your toolbars hide the workbook again (Window men, hide/unhide)

I customize my toolbars, but one day I open Excel and they have reverted to the default and I have to re-customize them. Any

ideas on how to KEEP my toolbars?

 

[Gord Dibben]

Toolbar and menu customizations are saved in *.XLB file.

Do a file search for *.XLB and locate where it(they, you may have more than
one).

Note the location(s) and make some changes to a Toolbar or menu then close
Excel and see which *.XLB is updating.

Save a copy of this *.XLB as you make changes. You can then copy it if you
lose it again.

Why are you losing it occassionally?? Are you on a network or stand-alone?
Servers can often screw up with file storage. If the *.XLB gets lost, Excel
just builds a new default one...as you have discovered.

Gord Dibben Excel MVP