Cell must contain values

[Jen]

Is it possible to create a code that would not allow a
user to perform an more activities in a spreadsheet if a
cell contained a certain value. I am trying to get to the
same effect as in Access when a field in a record must
contain a value or it will not allow you to do anything
else.

 

[Frank Kabel]

Hi
you could use an event procedure to achieve this 8and
protect the worksheet within this procedure). But this is
not as easy as in Access