PDA

View Full Version : Before send as attachment



wilg
11-09-2010, 11:09 PM
Hi. I have a file that before workbook close event hides tabs etc...
Is there code that if I select file, send to, mail recipient as attachment it will run code as I have before workbook close event. Thus hiding sheets.
Right now I always have to close the workbook and then send the file. Any help is appreciated.

Bob Phillips
11-10-2010, 12:59 AM
You can't send an open workbook as an attachment, but you could do SaveCopyAs to a temporary name, SaveCopyAs won't affect the open workbook, send that, then kill that copy