T
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.
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.