Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I recently updated Office 97 to Office 2003. When Excel 2003 came up it had
my customized toolbars from my 97 version and then after about a month Excel crashed. The toolbars that I have created come up alright, but it appears that Excel resets the default toolbars to their default state. For example, I added about 10 buttons to the Cut & Paste toolbar. When I closed Excel and reopened it I expected to see the altered Cut & Paste, but it was back to the default state. I have unloaded & reloaded Office 2003 twice with the same results. The name of the toolbar is Excel11.xlb and it is in the C:\Documents and Settings\chucks.SCAPCA\Application Data\Microsoft\Excel path. What is happening? I use the same toolbars on my home computerin Excel 2002 and it works fine. Personal.xls is fine. It has all of the macros that I have created. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you. I think this will solve my problem.
"David McRitchie" wrote: You want to rebuild you toolbars and different versions of Excel. You can get away with the same .xlb file on your own machine transferring to newer machine or hard drive, but I wouldn't really do it between home and work. Take a look at http://www.mvps.org/dmcritchie/excel/barhopper.htm to get a listing of your menus and toolbars and the macros you had. You will have to copy the buttons to the worksheet so that you can paste the images back to new toolbars. The format is the same as for John Walkenbach's Menu Editor so you can use that to restore them. You will have to modify macros to pick up your own name for the main menus that you may have added to the menus. You may find that you will have a new .xlb of 23KB instead of 450KB as an added benefit. --- 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 "Chuck Studer" <Chuck wrote in message ... I recently updated Office 97 to Office 2003. When Excel 2003 came up it had my customized toolbars from my 97 version and then after about a month Excel crashed. The toolbars that I have created come up alright, but it appears that Excel resets the default toolbars to their default state. For example, I added about 10 buttons to the Cut & Paste toolbar. When I closed Excel and reopened it I expected to see the altered Cut & Paste, but it was back to the default state. I have unloaded & reloaded Office 2003 twice with the same results. The name of the toolbar is Excel11.xlb and it is in the C:\Documents and Settings\chucks.SCAPCA\Application Data\Microsoft\Excel path. What is happening? I use the same toolbars on my home computerin Excel 2002 and it works fine. Personal.xls is fine. It has all of the macros that I have created. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Establish Default Titles For Drop Windows And Reset Button | Excel Discussion (Misc queries) | |||
Establish Default Titles For Drop Windows And Reset Button | New Users to Excel | |||
reset default 01/01/1900 date | Excel Discussion (Misc queries) | |||
How to reset Excel 2000 toolbars to "factory defaults"? | Excel Discussion (Misc queries) | |||
How do I reset default Excel window too view=fullscreen | Setting up and Configuration of Excel |