Hi ------,
You should be aware that you should recreate your toolbars
for *each* machine, not copy them among machines.
If you are going to transport your toolbars among your own
machines, try to make sure things are the same:
1) Same version of Excel, or you will probably get a bloated XLB file,
like maybe 10 times the size over a period of time.
2) Same pathname to your personal.xls, Excel remembers even if
you don't.
3) Only download and upload the xlb file when Excel is down,
Backup of an application should always be done with the application
down unless the backup is provided for in the application itself.
4) Above all don't put your XLB file on someone else's machine.
Just like you would not put your browser bookmarks on someone
else's machine.
Keep in mind that Excel saves the XLB file every time that Excel is
closed. In fact that allows you to do an emergency recovery if
you mess up your toolbars as long as you haven't closed or terminated
Excel.
http://www.mvps.org/dmcritchie/excel/toolbar.htm#emergency
Also keep in mind that Excel cannot have two workbooks with the same name
open at the same time, and that applies to your personal.xls file, this is
probably the source of most of your problems. Though with #4 you could
have a lot more at risk than a tool bar.
I would suggest that you run the macro found on my barhopper.htm page so that
can at least have a map of your toolbar layouts and icons, and can print it for reference.
Be aware that your own icons all have the same icon number through Excel 2002.
Barhopper -- fixup for Restored Toolbars, and -- Listing of Menu Items
http://www.mvps.org/dmcritchie/excel/barhopper.htm
http://www.mvps.org/dmcritchie/excel/code/barhopping.txt (debug version)
http://www.mvps.org/dmcritchie/excel/code/barhopper_ws.txt (worksheet version)
Also do a screen print of you toolbar layout, print it and store it in a filing cabinet.
I was glad to have had that a layout of my desktop on several occasions.
If you don't like the way something works and you have the code as with most
help in these newsgroups where macros are concerned and with many
of the add-ins, you can change it (experiment). If your modification works
you have just become a programmer (or the new buzzword "Developer").
somewhat for addins.
If language is a major concern there are several language newsgroups
for instance there is a German newsgroup:
news://msnews.microsoft.com/microsoft.public.de.excel
other international groups:
http://office.microsoft.com/en-au/assistance/ha010873021033.aspx
Though I think you will get a wider range of experience, and help around
the clock (around the world) more in the English language newsgroups.