I am trying to email an excel file as a PDF file to a supplier. The excel file has several sheets that I don't want the supplier to see.
I only want to mail sheet1, using 'File, Save & Send, Send as PDF'. When I do this all sheets are included in the PDF file I am sending.
Is there a way of doing this but limiting the PDF file to sheet1 only?
Bookmarks