Hi
try the following:
- first select all cells for which you want to ALLOW entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- after this goto 'Tools - Protection' and protect your sheet
Use the format cell function , then select the protection
tab.
Uncheck the the "locked" option then lock it for the cell
you want protected.
Then choose the tools, protect sheet, from the drop down
menu. put your password as normal and that cell will be
protected within the sheet.
If you also check the hidden box the formula will be
hidden as well.
-----Original Message-----
I am trying to protect one cell in a worksheet to keep
