Hiding Columns and Rows

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I use a shared Excell worksheet and im trying to hide rows
and colums but when another person opens the sheet they
can see the hidden rows that i hid. How can i hide rows
and colums and still have other users edit the sheet but
not see the hidden rows.
 
Hi Dan,

You could try the following:

Under the Worksheet Activate event-procedure put something like:


Columns("E:E").Select
Selection.EntireColumn.Hidden = True
Rows("11:11").Select
Selection.EntireRow.Hidden = True

the above code will hide Column "E" and Row "11" each time the sheet is
activated.

Hope it helps..
 
Back
Top