keep the VBA modules in Excel transferable among different computers?

  • Thread starter Thread starter Jim Cheng
  • Start date Start date
J

Jim Cheng

How could I keep the VBA modules in Excel transferable? In Other words, if I
copy an Excel file from one computer to another, how could I ensure that the
associated VBA modules are copied as well?

Everytime when I copy an Excel file to another computer, the data in the
Excel sheets are copyied, but not the VBA modules.

Any help in this matter would be greatly appreciated.

Thanks!

Jim
 
jim,

Are you storing the modules in the workbook or your
personal.xls? I have copied a number of workbooks in the
past, and the only time this is happened to me is when I
created the macros in personal.xls by mistake.

Steve
 
Back
Top