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

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

--
Don Guillett
SalesAid Software

"Marc" wrote in message
link.net...
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

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 he

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Marc" wrote in message
link.net...
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