Lock the cells and protect the worksheet

Select the cells that you wish to UNLOCK via FormatCells...Protection and
un-check locked.

Now go to toolsprotectionprotect sheet... and supply a password is
desireable. You will now not be able to change the 'locked' cells

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"keif" wrote in message
...
how do i prevent no data entry into a cell? my spreadsheet has some open
areas that i have "greyed out" cells to indicate no data entry - but how i
block them to prevent any data entry into the cell?