How to lock cells

Feb 11, 2011 at 3:43 PM

Hi Everyone,

Can somebody please guide me as to how to lock the cells in an excel sheet so that nobody can edit it when. I dont want the sheet to be password protected thoough. I just want all cells to be read only.

Thanks and Regards,

Heti

Coordinator
Feb 15, 2011 at 2:08 PM

Hi,

Set...

worksheet.Protection.IsProtected=true;

 

 Also, check out sample 7 and 10

Jan