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?

--
Many Thanks

Enquirer

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.

FormatCellsProtection. Uncheck "locked" option.

Now toolsProtectionProtect Sheet.

If some other application...........???


Gord Dibben Excel MVP

On Mon, 18 Apr 2005 18:05:39 GMT, "enquirer" 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?