Is there away to have specific cells unlock based on the entry of information in another?

[Marc]

Is there away to have specific cells unlock based on the entry of
information in another? I want to have a series of questions that have to
be answered before you can enter information into a corresponding set of
cells. I would also need to have the answer generate a value in another
cell.

Marc

 

[Don Guillett]

Lot's of ways using a worksheet_change event, input boxes, etc. tied to a
macro that unlocks based on the answers or the cells data

 

[Ragdyer]

Sounds as though "Data Validation" would be one way to go.

You can prevent data entry into a cell until a criteria is met in other
cells.

Check it out in the Help files and also here:

http://www.mvps.org/dmcritchie/excel/validation.htm