Excel97 Custom Toolbars disappeared

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zilbandy - 14 Oct 2006 09:01 GMT

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.

Signature

Zilbandy - Tucson, Arizona USA <zil@zilbandyREMOVETHIS.com>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Reply to this Message

Jim Cone - 14 Oct 2006 16:33 GMT

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?

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

Signature

Reply to this Message

Zilbandy - 14 Oct 2006 20:29 GMT

>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?

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. :(

Signature

Reply to this Message

Dave Peterson - 14 Oct 2006 22:02 GMT

Find that *.xlb file and back it up to a nice spot. If you have troubles, just
copy the backup version.

> >For what it is worth...
> >my xl97 .xlb file is named... "User8.xlb" and is located in C:\WINDOWS.
[quoted text clipped - 10 lines]
> PGP Public Key: http://zilbandy.com/pgpkey.htm
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Signature

Dave Peterson

Reply to this Message

Zilbandy - 14 Oct 2006 22:22 GMT

>Find that *.xlb file and back it up to a nice spot. If you have troubles, just
>copy the backup version.

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.

Signature

Reply to this Message

Zilbandy - 14 Oct 2006 22:33 GMT

>>Find that *.xlb file and back it up to a nice spot. If you have troubles, just
>>copy the backup version.
>
>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.

I must have goofed. It worked this time. I hate getting old. LOL

Signature

Reply to this Message

Dave Peterson - 14 Oct 2006 22:33 GMT

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.

> >Find that *.xlb file and back it up to a nice spot. If you have troubles, just
> >copy the backup version.
[quoted text clipped - 8 lines]
> PGP Public Key: http://zilbandy.com/pgpkey.htm
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Signature

Dave Peterson

Reply to this Message