Macro in .xla

E

Eric1701

HI everyone,

I am fairly new at Building macros in EXCEL (I use excel2000 BTW). I
have one that i have to distribute to about 6 other users. I have been
told that putting it in an.XLA file would be better.

Whats the Difference between an XLA file and A module and is there a
simple way to do that?

Thanks

Eric
 
B

Bob Phillips

An XLA is just an Excel workbook that is saved as an XLA. Then it is
installed via Tools>Addins, and the macros become availabe.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top