Excel97 Custom Toolbars disappeared

  • Thread starter Thread starter Zilbandy
  • Start date Start date
Z

Zilbandy

I reinstalled Office 97 to fix a problem with MS Access and now my
custom toolbars that I made in Excel have disappeared. On a happy
note, my Access problem is fixed. LOL I searched for *.xlb files and
didn't find any on my hard drive. I searched an Image backup of C
drive I made yesterday and there is one .xlb file in that backup and
it's located in c:\windows (I'm using WinXP Home SP2 fully patched). I
copied this file to my current windows folders, but that didn't do
anything in helping me find the missing toolbars. I really don't want
to build new toolbars if I can avoid it. Thanks.
 
For what it is worth...
my xl97 .xlb file is named... "User8.xlb" and is located in C:\WINDOWS.
I am also using WinXP home.
Did you close and restart XL?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


I reinstalled Office 97 to fix a problem with MS Access and now my
custom toolbars that I made in Excel have disappeared. On a happy
note, my Access problem is fixed. LOL I searched for *.xlb files and
didn't find any on my hard drive. I searched an Image backup of C
drive I made yesterday and there is one .xlb file in that backup and
it's located in c:\windows (I'm using WinXP Home SP2 fully patched). I
copied this file to my current windows folders, but that didn't do
anything in helping me find the missing toolbars. I really don't want
to build new toolbars if I can avoid it. Thanks.
 
For what it is worth...
my xl97 .xlb file is named... "User8.xlb" and is located in C:\WINDOWS.
I am also using WinXP home.
Did you close and restart XL?
Click to expand...

Yes, I restarted Excel. I rebooted the computer. Didn't make a
difference. I wound up recreating the toolbars, but I hope I don't
have to do another repair installation in the future. :(
 
Find that *.xlb file and back it up to a nice spot. If you have troubles, just
copy the backup version.
 
Find that *.xlb file and back it up to a nice spot. If you have troubles, just
copy the backup version.
Click to expand...

That didn't seem to work. I restored that .xlb file from a backup of
my system made when all was working. Maybe I goofed. I'll play some
more.
 
That didn't seem to work. I restored that .xlb file from a backup of
my system made when all was working. Maybe I goofed. I'll play some
more.
Click to expand...

I must have goofed. It worked this time. I hate getting old. LOL
 
Maybe you restored your backup to the wrong spot.

I like to modify a toolbar, close excel and search for *.xlb. The one that has
today's date/time on it is the real *.xlb file. Make a note of its location.

I'd delete all the others (make sure you search through hidden folders for
hidden files).

And then see if you can restore your backup to that location. Use the same name
as the one you found and noted.
 
Back
Top