View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh C Josh C is offline
external usenet poster
 
Posts: 55
Default Copying sheets into a new work book

I would like to make it an option for users of a program that I created in MS
Excel 2003 to save eight sheets and the data into a new workbook. I would
like to do this because there is sensitive information in the original
program and they will not be able to email a copy of that with the updated
material. The sheets that I want copied to email should not have any material
that cannot be seen. I would like the workbook to be named in this fashion if
possible: €śEmail Version <producerName€ť on to the users desktop. If the
workbook is on the desktop, the user can move it or email it from there as
needed.