MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Emma Scanu on March 15, 2000 6:19 AM

Does anyone know how to protect individual cells rather than the whole worksheet?

Posted by kid on March 15, 2000 7:58 AM


1st press ctrl that means u select all the range in your worksheet
2nd press ctrl1 that means u want to format cell
3rd on format cells pick protection , n make
sure locked is tick

4th u pick the cell u want to unprotect
n on format cells make sure u untick
the locked

5th go to tools tab menu
pick protection and protect
your w/sheet with password

Posted by Joseph on March 15, 2000 8:05 AM

By default, an Excel worksheet has the protection status of all cells set to locked, but this doesn;t take effect until you protect the worksheet.

To lock or unlock specific cells, unprotect the worksheet (if it is currently protected), highlight the cells you want to unlock and select Cells from the Format menu and click the protection tab and remove the tick from the Locked box.

Reprotect the sheet. Job done.

Posted by Jackal on March 15, 2000 8:17 AM

next time turn off your caps lock when posting....

Posted by Celia on March 15, 2000 8:18 AM

Go to :-

and look at :-

19. FobidRange VBA.xls