View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill James[_2_] Bill James[_2_] is offline
external usenet poster
 
Posts: 13
Default 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...