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
-----Original Message-----
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


.