How to share active worksheet as a PDF

Occasional Visitor

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.