MrExcel Publishing
Your One Stop for Excel Tips & Solutions

protecting a cell


Posted by Ronnie on January 03, 2001 12:15 PM

I want to protect a cell from being erased.


Posted by Anjali on January 03, 2001 12:25 PM

hi Ron,

you can lock a cell as follows:

Sheets("sheetname").Cells(rowcount, colcount).Locked=true
Sheets("sheetname").Protect contents:=True

HTH,
Anjali