How to unhide a column after printing

[Guest]

Hi,

I have a simple problem: just before printing (by using the
Workbook_BeforePrint event), I hide a column that I don't want to be printed.
But because there is no AfterPrint event, I have no idea how to unhide that
same column just after the print has been completed.

Can anyone give me a solution to the problem ?

Thanks
Balex

 

[David]

=?Utf-8?B?QmFsZXg=?= wrote

Hi,

I have a simple problem: just before printing (by using the
Workbook_BeforePrint event), I hide a column that I don't want to be
printed. But because there is no AfterPrint event, I have no idea how
to unhide that same column just after the print has been completed.

Can anyone give me a solution to the problem ?

Thanks
Balex

Call this from your BeforePrint event with
Application.OnTime Now, "WorkbookAfterPrint"

Sub WorkbookAfterPrint()
Cells.EntireColumn.Hidden = False
End Sub

 

[Guest]

Hey, tons of thanks, David, works like a breeze. I could have searched for
ever on my own before discovering that one...

Balex