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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot unhide the hidden rows in my spreadsheet 3
Hiding colums when saving as html 4
copying some rows and columns 21
Macro to hide rows with zero in specifc column range 2
hide, unhide column or row after protect worksheet 4
hiding rows 5
Numbering rows with filters 1
Hidding rows when sorting 1

Back
Top