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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top