Thread: How to unhide a column after printing

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

=?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

--
David

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

Balex

"David" wrote:

> =?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
>
> --
> David
>