View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Kwok Andy Kwok is offline
external usenet poster
 
Posts: 1
Default Copying a sheet to new work sheet

Hi,

I have a workbook with macros copying data from one sheet into
another.
This works fine. However, I want to e-mail the sheet that is created
but not the entire workbook as its 5 megs.

I have tried to copy/move the sheet into a new workbook but it also
copies
the macros. When I remove the module the file still remains at 5 megs.
I would appreciate any help.

Thanks

Andy