hide columns before printing
in [General]
|
From: Jean-Paul De Winter on 15 Apr 2010 02:24 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 15 Apr 2010 03:02 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 15 Apr 2010 04:40 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 15 Apr 2010 06:54 ??? ozgrid.com wrote: > Define a Custom View. > >
From: ozgrid.com on 15 Apr 2010 22:19
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. >> |