Save As PDF on Mac

Hello!

I have been trying to find the VBA code for the Mac as it is working well on Windows. Here is the VBA code for Windows:

Please Login or Register  to view this content.

This code will save the entire worksheet, I did change ThisWorksbook to ThisActivesheet, but it did not work as I only want to save one active sheet called "Invoice," not the entire worksheet. I would like to know how to save as the PDF on Mac? I also would like to see if it is possible for me to type a filename manually after before I save the PDF. Is it possible to save it under Documents rather than on the desktop? It would be challenging to track invoices if I use to like this invoice 28.09.2018.pdf. I want to input the name company, invoice #, and date by manually. Last, when I close the Excel and open it again, the invoice number will be remain. Is there a way to increment the invoice number when opening the Excel?

Thanks in advance!

Cross-posted at: https://www.mrexcel.com/forum/excel-...e-pdf-mac.html
Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html

Obviously, you have not bothered to read the forum rules that you agreed to when you joined this forum. Please do so now.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)