If one records a macro in Excel they have the option of saving the macro to
the Personal.xls directory for global use. How does one do this with a
subroutiune already written in VBA? Do you export?

Marvin,

The simplest way is to simply cut and paste the code from one
module to another.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Marvin Johnson" <Marvin wrote
in message
...
If one records a macro in Excel they have the option of saving
the macro to
the Personal.xls directory for global use. How does one do
this with a
subroutiune already written in VBA? Do you export?

Marvin,

You can just copy and paste it in the VBE.

hth,

Doug

"Marvin Johnson" <Marvin wrote in message
...
If one records a macro in Excel they have the option of saving the macro
to
the Personal.xls directory for global use. How does one do this with a
subroutiune already written in VBA? Do you export?

If the code is in its own module, you could just drag the module from that
project to the personal.xls's project.



Marvin Johnson wrote:

If one records a macro in Excel they have the option of saving the macro to
the Personal.xls directory for global use. How does one do this with a
subroutiune already written in VBA? Do you export?

--

Dave Peterson