Remove worksheet before send

[tylerg11]

I would like to remove a worksheet from my workbook on the send command so that the receipent doesn't have acces to it, and it isn't displayed on the bottom tabs, but still in the original file. How can I accomplish this?

 

[careywalker]

Can you delete the worksheet on the send command and then close without saving the file? Or you could make a copy of the workbook and delete the sheet from the copy and then send the copy. Does this help?

 

[tylerg11]

Good ideas. Could I accomplish all that with macros? Or will I need to use VBA?

 

[careywalker]

Macros use vba. I think what you are asking is can you do this using the macro recorder. The answer is I don't know but you can try and see what happens. Actually what you could do is record the macro, delete the sheet and then send it. Stop recording the macro before you make the save after deleting the sheet. This will ensure the save function does not get included in your recorded macro. Let us know if this works.