2.. By default all cells on a sheet are locked when the sheet is protected.

Select cells to enter data and FormatCellsProtection. Uncheck "locked"
and OK

ToolsProtectionProtect Sheet

1. Can be done through Data Validation but you will have some very PO'd
people who type 500 + characters and are told that is not valid and have to
re-type.

Why the 500 char limit?

Perhaps some event code that will truncate all but the first 500 characters?


Gord Dibben MS Excel MVP

On Mon, 15 Dec 2008 07:22:04 -0800, tates
wrote:

I am building a form and:

1. need to limit the text response to 500 characters in a single cell.
2. need to protect all the cells except those I want the user to enter
information in

Can anyone help me?