Hi
I want to save a userform as a PDF file but I dont want to use printform. I just want to make a button that save the file and another button for printing on defaultprinter. The printbutton is not a problem the problem is how to save as a PDF without using printform.
Found this a long time ago.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
From the depths of my archives.
I have attached it to a recent UserForm, click small (command button) bottom right hand corner.
Close off app without saving, PDF should be on your desktop.
Acknowledgements to OP are in the code window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks