Reassigning macro locations for toolbar buttons

[dm59]

Hello
I have custom toolbar button with macros assigned to them.
Periodically, they all get re-mapped to look for them in a worksheet
file that may or may not be accessible. The intent is for the toolbar
button to look in my "personal.xls" file for the macros but, for some
unknown reason, the "remapping" happens.

Why would something like this happen?
Is there a way to remap them all back to the personal.xls file in one
shot? Right now, I have to go into each button and do it manually, one
at a time. There must be a way to say "for all buttons, look here".

Any help would be very much appreciated.

 

[Dave Peterson]

I think you'll find your life much simpler if you just create the toolbar when
the workbook opens.

If you want to add an option to the worksheet menu bar, I really like the way
John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

 

[dm59]

I think you'll find your life much simpler if you just create the
toolbar when
the workbook opens.Thanks Dave. I had a problem with this reply. I hope it isn't

duplicated. Anyway, I'm hoping to have my toolbar config available
always, with no manual loading of "stuff". Personal.xls does this but I
get in trouble every now and then where a workbook I load causes Excel
to look in it for the source of the macro code, rather than looking in
personal.xls, as I had originally set up.

I'm hoping that, once this happens, like right now, I can somehow tell
Excel to look in personal.xls for all of my toolbar button assignments
and save me from having to go into each one of them and do the
re-assignments.

 

[Dave Peterson]

Have your personal.xls workbook create the toolbar. Lots of people do it that
way.