How do I E-mail a Macro to another person so that they can use it

[Phyllis K.]

I have created macros that must be used in other offices when they receive
new files. I am having difficulty sending the macros by E-mail. If I send the
Personals sheet, sometimes it is blank.

 

[Nick Hodge]

Phyllis

You can export macros by pressing Alt+F11 and right clickin on the macro in
the project explorer, selecting export. It exports a .bas file and this can
be imported in the same way

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)