From: Jean-Paul De Winter on
Hi,

Before actually printing my sheet I want to hide column A and B.
Can I do this automatically without having to hide them manually?

Thanks

--

Mvg.
Jean-Paul De Winter


From: Jarek Kujawa on
press ALT+F11 to get to VBA
then in Project-VBA Project window double click on ThisWorkbook
put this code into the window to the right:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("A:B").Columns.Entirecolumn.Hidden = True
End Sub


HIH
pls click YES if it helped


On 15 Kwi, 08:24, "Jean-Paul De Winter" <jp.dewin...(a)pandora.be>
wrote:
> Hi,
>
> Before actually printing my sheet I want to hide column A and B.
> Can I do this automatically without having to hide them manually?
>
> Thanks
>
> --
>
> Mvg.
> Jean-Paul De Winter

From: ozgrid.com on
Define a Custom View.


--
Regards
Dave Hawley
www.ozgrid.com
"Jean-Paul De Winter" <jp.dewinter(a)pandora.be> wrote in message
news:Yiyxn.11555$5D3.8188(a)newsfe03.ams2...
> Hi,
>
> Before actually printing my sheet I want to hide column A and B.
> Can I do this automatically without having to hide them manually?
>
> Thanks
>
> --
>
> Mvg.
> Jean-Paul De Winter
>
>

From: Jean-Paul on
???

ozgrid.com wrote:
> Define a Custom View.
>
>
From: ozgrid.com on
Read your Excel Help on "Custom Views"


--
Regards
Dave Hawley
www.ozgrid.com
"Jean-Paul" <jp.dewinter(a)telenet.be> wrote in message
news:kfCxn.106024$T_2.5559(a)newsfe19.ams2...
> ???
>
> ozgrid.com wrote:
>> Define a Custom View.
>>