View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default HOw DO I EMAIL AN EXEL MACRO TO ANTOEHR USER?

1. First unhide personal.xls
2. Using Notepad open a new, empty doxument
3. Using the VB editor, open the macro
4. Copy the macro into the notepad document and save the notepad file as .txt
5. Mail the .txt file as an attachment
--
Gary's Student


"leo" wrote:

I have excel macro that get stored in xl file "personnel". when i open the
"personneL" file i can't see any data in it. that being said how do i email a
macro if i can't even see the macro file.