View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Saving Excel VBA code to Personal.xls

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?