Sub PrintActions()
Dim P As Byte
P = MsgBox(Range("Database!K33"), vbYesNo + vbDefaultButton12)
If P = vbNo Then Exit Sub
Application.Dialogs(xlDialogPrinterSetup).Show
With Sheets(Actions)
.PageSetup.PrintArea = "$B$2:$J$244"
With .PageSetup
.PaperSize = xlPaperA4
.Orientation = xlPortrait
.Zoom = False
.FitToPagesWide = 1
.BlackAndWhite = True
End With
.PrintOut Copies:=1
End With
End Sub