View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
siva siva is offline
external usenet poster
 
Posts: 6
Default Need to lock 2 rows in a sheet

Hi All,

Please help me out with the steps to lock 2 specific rows in a sheet.
All other rows should have full access for all users and only 2
specific rows should be given with read access..

I tried,
All cells were formatted with no locked option
2 rows which require read only access was selected with locked
formatting
Then chose protect workshhet with password
But this one locks the entire worksheet

PLz help..

With Regards,
Sivaji