Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative Macro Assignments in Custom Menus
Hi,
I am trying to import some menus and the corresponding macros assigned to them from one machine to another. As so, I am over-writing my PERSONAL.xls file (that is where my macros are stored) and also over-writing my Excel11.xlb menu file. The menus pop on the new machine but upon trying to run my macros, I get a failure. Under the menu buttons, Excel looks for the macros in: C:\Documents and Settings\"username1"\Application Data\Microsoft\Excel\PERSONAL.xls However, on the new machine the location of PERSONAL.xls changes since there is a different user, "username2". Is there a way to assign a relative location for the macros? I want Excel to look for the macros in "PERSONAL.xls" regardless of the user. Thanks Ivo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Custom Toolbar Button No Longer Runs Assigned Macro | Excel Discussion (Misc queries) | |||
Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) |