Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
how to customize Default Toolbars in Excel for ALL Workbooks
I like the toolbars a certain way. is there any way i can get that toolbars
to automatically come up w/ each new worksheet? as opposed to customizing every worksheet i open? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
how to customize Default Toolbars in Excel for ALL Workbooks
Menu and Toolbar customizations are stored in your Excelx.xlb file
"x" is a version number like 9 for 2000, 10 for 2002 and 11 for 2003. If it gets too large, it can become unstable. Or perhaps if on a network, Excel is confused about where to store it. Do a search for this file. There could be more than one *.xlb file so may have to check all copies to see which is loading. Usually stored in.................. C:\Documents and Settings\username\Application Data\Microsoft\Excel When found, 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? Reopen Excel. Have your changes stuck? Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 22:53:02 -0700, Just Curious... <Just wrote: I like the toolbars a certain way. is there any way i can get that toolbars to automatically come up w/ each new worksheet? as opposed to customizing every worksheet i open? Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
how to customize Default Toolbars in Excel for ALL Workbooks
Thank You!
"Gord Dibben" wrote: Menu and Toolbar customizations are stored in your Excelx.xlb file "x" is a version number like 9 for 2000, 10 for 2002 and 11 for 2003. If it gets too large, it can become unstable. Or perhaps if on a network, Excel is confused about where to store it. Do a search for this file. There could be more than one *.xlb file so may have to check all copies to see which is loading. Usually stored in.................. C:\Documents and Settings\username\Application Data\Microsoft\Excel When found, 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? Reopen Excel. Have your changes stuck? Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 22:53:02 -0700, Just Curious... <Just wrote: I like the toolbars a certain way. is there any way i can get that toolbars to automatically come up w/ each new worksheet? as opposed to customizing every worksheet i open? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I restore the default settings in Excel 2003? | Setting up and Configuration of Excel | |||
Using alt-tab to switch between Excel workbooks under the same session | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I change the default margins for workbooks in Excel? | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |