View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Reassigning macro locations for toolbar buttons

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 wrote:

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.

--
dm59
------------------------------------------------------------------------
dm59's Profile: http://www.excelforum.com/member.php...o&userid=30398
View this thread: http://www.excelforum.com/showthread...hreadid=500667


--

Dave Peterson