Hiding Rows & Columns

  • Thread starter Thread starter Paul B
  • Start date Start date
P

Paul B

Khalil, try this,

Private Sub Worksheet_Activate()
Columns("U:IV").EntireColumn.Hidden = True
Rows("101:65536").EntireRow.Hidden = True
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
It worked for me

Are you sure you put it in a worksheet module instead of a workbook or
regular module? It only works then for that one sheet.

Vaya con Dios,
Chuck, CABGx3

..
 
Hi,
to hide some columns and rows in a work sheet
I tried this code for the active worksheet using VB editor but it did not
work. I dont know if i missed something?

Private Sub Worksheet_Activate()
Columns("U:IV").Hidden = True
Rows("101:65536").Hidden = True
End Sub

Can any one knows why?

Khalil
 
Back
Top