Marco to save to a single PDF

[LGexcel]

Hi!

I am new to VBE in Excel, so please bare with me FYI, I am a Mac Excel 2011 user.

I have set up a marco button that when clicked, a pop up displays listing all the active worksheets. The user selects the sheets he/she wants to print, then it prints to the default printer.

But I now want to set this up so it saves all selected worksheets to a SINGLE pdf file. Ideally, I would also like it to ask the user what file name he/she wants to save it as. And select a destination.

Below is my current code. Any advice would be greatly appreciated. Thank you!

Private Sub CheckBox2_Click()

End Sub

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alansidman]

Your post does not comply with Rule 3 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 here



(I have added them for you today. Please read all the forum rules and comply in the future.)

[LGexcel]

Does anyone have any advice? Thanks in advance.