hide columns only when printing

[y481184]

Is there any way in excel to hide a column only when the report is being printed. In other words, I have a couply of columns that I would like to keep on my report, but I don't want them to print. Do I have to manually hide each of these columns when I go to print the document?

[LTunnicliffe]

Try:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
**
**Cancel = True
**Application.EnableEvents = False
****ActiveSheet.Columns(1).Hidden = True
****ActiveSheet.PrintOut
****ActiveSheet.Columns(1).Hidden = False
**Application.EnableEvents = True
**
End Sub

Specify the columns you want hidden where I have the Columns(1) line. Put this in the ThisWorkbook module of the VBE (ALT+F11). Let me know if you have problems.