Save Excel Userform to PDF

[cpieramico]

I have a multi-page Excel Userform that is currently set to print to the user's default printer upon clicking a command button. I would like to change this so that the form prints to PDF but I can't seem to find the right code.

If possible, I would like all three pages of the userform to print to one PDF file.

Any help would be much appreciated!

[bulina2k]

Hi there!

If you have a PDF printer installed you can insert

Please Login or Register  to view this content.

so the user can choose the PDF printer.

[cpieramico]

I added your code and it did bring up a dialog box so I could select CutePDF Writer as my printer, but the PDF document never opened. I added Me.PrintForm after your code and tried again, but still didn't see a PDF file open. Any suggestions? I think we're on the right track.

[bulina2k]

You didn't see a PDF file open but did CutePDF created a file on its default folder? (or last used folder?)

[cpieramico]

If it did I can't find where it saved the file. What I really need is for the PDF copy to open up so that the user can then either save it or print it. Is that possible?