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 toolbar buttons. Then you could save a copy of the macro kept in master file 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 the long run.

Sincerely,
Leith Ross