Saving Excel VBA code to Personal.xls

[Guest]

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?

 

[Chip Pearson]

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



in message
news:[email protected]...

 

[Doug Glancy]

Marvin,

You can just copy and paste it in the VBE.

hth,

Doug

 

[Dave Peterson]

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