Limitations to user entry are done by locking a cell under
Format=Cell=Protection tab (locked is the default value)

Then protecting the worksheet. (the locked setting is not enforced until
the sheet is protected). This, of course, imposes many limitations.

If the user is only to be excluded after making an entry, then you would use
the change event to unprotect the sheet, lock the cells, then reprotect the
sheet.

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi all,

I have input area on my sheet as following :

Item1
Item2
Item3
Item4

each of them sittin on one cell, I would like users to input from item1 to
item4 and I did it by using formula, but after input users can also erase
item1 and make a blank cell about item2. How to prevent it?

Clara

--
thank you so much for your help