D
D Anderson
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?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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)
---
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
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)
---
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
ideas on how to KEEP my toolbars?D Anderson said: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
G
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
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