How to Lock cells and have them be unlocked based on a cell beingfilled with an "x"

[hak0828]

To anybody kind enough to take the time to read my post,

I am working on a very simple and basic excel workbook in which I have
many work sheets for different clients with a questionnaire that each
client must complete

One of the questions requires either it be left blank or marked with
an "x".

The question is located in column S and applies to all account of the
clients. If an "x' is placed, then I would like the three following
columns to be unlocked (column T, U, V) so that they can be answered.

Is there anybody who can help me.

Thank you so much for your time,

Hakan

(e-mail address removed)

 

[Bob Greenblatt]

To anybody kind enough to take the time to read my post,

I am working on a very simple and basic excel workbook in which I have
many work sheets for different clients with a questionnaire that each
client must complete

One of the questions requires either it be left blank or marked with
an "x".

The question is located in column S and applies to all account of the
clients. If an "x' is placed, then I would like the three following
columns to be unlocked (column T, U, V) so that they can be answered.

Is there anybody who can help me.

Thank you so much for your time,

Hakan

(e-mail address removed)

The only way to do this is with a macro. A formula can not unhide (or
whatever you mean by "unlock") columns. What version of Excel are you using?

 

[hak0828]

Bob,

I am using Excel 2003.

If you could help me contruct a macro for this that would be very
helpful.

To be honnest I am very unfamiliar with running macros and therefore
the more information you can present me with the better.

Thanks in advance

Hakan Erol

 

[Bob Greenblatt]

Bob,

I am using Excel 2003.

If you could help me contruct a macro for this that would be very
helpful.

To be honnest I am very unfamiliar with running macros and therefore
the more information you can present me with the better.

Thanks in advance

Hakan Erol

Please give me some specifics as to what cell may contain the "X" and what
columns to show or hide depending on the value.

And, by the way this is a forum for Macintosh Excel, thus the .mac. In the
forum title.