The Case of the Disappearing Macro Tool Bars

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Jeffery - 18 Oct 2004 07:27 GMT

HI,

I'm using Excel 97 on WINNT.

I use a number of toolbars linked to macros to perform a series o
functions I have automated. I have installed similar tool bars for man
of my colleagues.

For reasons unknown, my tool bars regularly disappear and I have t
re-make them.

Does anybody know why this happens and, more importantly, is there an
way to prevent this or store them somewhere for a quick re-install?

TIA.

Lee Jeffery

Reply to this Message

BrianB - 18 Oct 2004 15:40 GMT

I have used he same setup as yourself for some years without problem
Perhaps you have a toolbar thief around. :confused:

Custom toolbars are stored in files with a *.xlb suffix. Mine is i
C:\WINNT folder in a file like MYUSERNAME8.xlb. I have successfull
transported this home and used from in my XLSTART folder for Exce
2000. I suppose it just need to be somewhere that Excel searches o
opening

--
Brian

Reply to this Message

Gord Dibben - 18 Oct 2004 23:16 GMT

Lee

Manual customizations to Menus and Toolbars are saved in a file named *.XLB

Excel 97 in C:\Windows and named username.XLB

Perhaps this file is going astray? If on a server, this can happen.

Also if on a server, you may not have permissions to save. See your IT person
or Administrator.

Search for *.xlb and see what you come up with. When you get your
customization done, make a backup copy of the *.xlb file.

You may find more than one. Make a Toolbar or Menu change and see which *.XLB
file updates.

One more fact about *.xlb files. If they become too large, they
have been known to cause problems with Excel.

Gord Dibben Excel MVP

>HI,
>
[quoted text clipped - 13 lines]
>
>Lee Jeffery.

Reply to this Message