Print Form

Hello,
I would like to add a Command Button to a form so that I can print the form. Is there an easy code to make this happen?

Awesome. Thank you. I will give it a try.

That worked perfectly. Any idea how to center the form on the printed page? This doesn't generate a Preview screen.

Thanks a ton!

Attached is a workbook where there are 3 options on buttons on sheet 1
Print All - Prints entire workbook
Print Page - Prints current worksheet
Print selection - Menu to choose the sheets you want to print

I hope this helps and works really well for me in numerous projects

Mark

You're a rockstar. Thanks!

Is there a Macro that can be assigned to a button for Print Preview? The form prints using the above listed code, but its not centered.