We are using the latest desktop version of Excel O365. The share button allows you to email an Excel workbook as a PDF. It will share all worksheets using their respective print area settings as what it will "print" on the PDF. Is there a way to share only the active worksheet as a PDF? The only way to do this would be to use the export as a PDF and make sure the options are set to active worksheet only. The draw back with this is you have to save a new document, and then create a new email and attach it. Looking for that magic one button for users.
Thank you.
