Cell must contain values

  • Thread starter Thread starter Jen
  • Start date Start date
J

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.
 
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
 
Back
Top