Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Macro & Paths
When assigning a macro to a command button you can select the macro from any
open workbooks, but after the workbook is saved and moved to another computer, the full path of the original workbook containing the macro is saved with the button. Is there a better way to handle beside placing the macro in Personal.xls? I'd like to use one container for the macros associated with the project... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Macro & Paths
Hello Bill, You could use Control ToolBox buttons instead of the Forms toolba buttons. Then you could save a copy of the macro kept in master fil with the project. The macros would then move with the workbook project This would mean a little more work initially, but would pay off in th long run. Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=47894 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign Macro | Excel Discussion (Misc queries) | |||
Macro paths wrong after save | Excel Discussion (Misc queries) | |||
Assign a Macro | Excel Discussion (Misc queries) | |||
assign a macro | Excel Discussion (Misc queries) | |||
still can't assign MACRO | Excel Programming |