Toolbar Error - can't find macros

[Tim879]

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

 

[Dave Peterson]

Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions 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)

 

[Tim879]

Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

 

[Tim879]

I should rephrase that - I meant toolbars.

Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

 

[Dave Peterson]

The second link is what I use when I want a toolbar.

 

[Tim879]

I see how the second link works, but unless I am misunderstanding your
point, that would mean I need to recreate my toolbars.

Is there any way to do this where I don't have to recreate them?

 

[Dave Peterson]

You could loop through the toolbar icons and reassign the macro, but that is a
temporary measure. If you move to another pc, then you're going to have the
same problem.

But if you want, you could look at this code:

http://groups.google.co.uk/group/mi...subject:Laptop"&rnum=1&hl=en#c6b36967034ce7cb

or

http://snipurl.com/hwet

I still think building the toolbars on the fly is easier in the long run.

 

[Tim879]

Dave,

Thanks for the replies and your help. I really appreciate it. I
definitely plan to use your technique going forward.

Have a great day!
Tim