If referring to MS Excel workbooks/worksheets..........
By default, all cells are locked when you protect the sheet.
Select the cells you wish to leave unlocked for entry.
Format>Cells>Protection. Uncheck "locked" option.
Now tools>Protection>Protect Sheet.
If some other application...........???
Gord Dibben Excel MVP
On Mon, 18 Apr 2005 18:05:39 GMT, "enquirer" <enquirer.com@virgin.net> wrote:
>I have Psion Series 3MX that has spreadsheet software called Sheet. In
>Sheet, I can Protect individual cells, so that another user can't alter its
>content, but leave specific cells unprotected for the user to enter their
>own figures.
>
>How can I do this with Excel. I have tried, but seem to only be able to
>Protect the whole sheet and not leave individual cells unprotected?
Bookmarks