Print Form

[tapsmiled]

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?

[6StringJazzer]

Yes. I have not tested this specific code since I don't have your file.

Please Login or Register  to view this content.

[tapsmiled]

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

[tapsmiled]

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

Thanks a ton!

[markharris2004]

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

[tapsmiled]

You're a rockstar. Thanks!

[tapsmiled]

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.