Blanchetdb
Board Regular
- Joined
- Jul 31, 2018
- Messages
- 161
- Office Version
- 2016
- Platform
- Windows
Hi
I have a form that I would like to have the print function defaulted to Print to PDF
I also would like the person to be able to preview the print prior
this is the code I presently have that allows me to preview but not sure what to add in order for it to default to "Print to PDF"
I have a form that I would like to have the print function defaulted to Print to PDF
I also would like the person to be able to preview the print prior
this is the code I presently have that allows me to preview but not sure what to add in order for it to default to "Print to PDF"
Code:
Private Sub CommandButton2_Click()
Sheets("Sheet3").PrintOut From:=1, To:=1, Copies:=1, Preview:=True
End Sub