Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck Studer
 
Posts: n/a
Default Toolbars reset to default after a crash.

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default Toolbars reset to default after a crash.

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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck Studer
 
Posts: n/a
Default Toolbars reset to default after a crash.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Establish Default Titles For Drop Windows And Reset Button travelersway Excel Discussion (Misc queries) 0 October 17th 05 12:31 PM
Establish Default Titles For Drop Windows And Reset Button travelersway New Users to Excel 0 October 17th 05 11:58 AM
reset default 01/01/1900 date Phil Excel Discussion (Misc queries) 1 August 24th 05 03:10 PM
How to reset Excel 2000 toolbars to "factory defaults"? [email protected] Excel Discussion (Misc queries) 3 March 28th 05 10:39 PM
How do I reset default Excel window too view=fullscreen needyourhelp Setting up and Configuration of Excel 4 March 7th 05 10:37 PM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"