Assign Macro & Paths

[Bill James]

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

 

[Leith Ross]

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