I have a module that prints my worksheets.
UserResponse = MsgBox(Prompt:="Print Worksheet (Yes) for Print Preview", Buttons:=vbYesNoCancel, Title:="Print Worksheet")
Select Case UserResponse
' ActiveSheet.PrintOut Preview:=True
The "PrintToFit" is just another called module that scales the print to fit one page.
I would like to have the function that when a worksheet is print it does not print any of the command buttons as see below: