Hello,
I see these codes in my book:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
'Hide columns B:D on Sheet1 before printing
Worksheets("Sheet1").Range("B:D").EntireColumn.Hidden = True
End Sub
but I am questioned about two things:
  1. Why add Cancel As Boolean on the first row?
  2. Why add EntireColumn before Hidden
It didn't use Cancel at all and Range("B:D") are three columns exactly.
Thanks.