Re: Toolbar macros, Personal.xls and the .xlb file

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 (work*** 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.
---
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

"pmatziaris" <pmatziaris@xxxxxxxxx> wrote in message news:1148556264.150890.221750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
First of all I want to thank all that they tried with their e-mails to
help me. Also I want to stress in all that I know a few things about
the VBA and cannot modify the routines that you send to me also what
for some simple perhaps reason they do not work in my PC. My initial
(and unique) problem is that I do not want each time where I copy the
excel.xlb in other PC or in other User to change manualy the path in
which it is found the personal.xls for each button of my toolbars
separately. Finally, I can't occupy which way is useful in toolbars the
"John Walkenbach's Menu Maker tip 53" that does show how can somebody
create custom menus?

P.s. : I apologize for the bad knowledge of English language. At least,
I hope you understand the meaning of my written.



.