--------------------------------------------------------------------------------
How's it going guys? I need a but of assistance with one of my spreadsheets (I am using excel 2000, and not the newest versions.)
The first three columns are typical lists, the problem comes next. I need these to remain unlocked.
I have a working validation list in Column D that has 3 items that for each row one must be chosen.
Based on this choice I need corresponding cell in that row unlocked, and the others to remain locked. Example in Column D, we choose Choice1 I need E,F and G unlocked and H, and I locked.
Situation 2, Choice 3 I need E, F and G Locked with H and I unlocked.
If any of you guys can help me with this I would be greatly indebted.
How's it going guys? I need a but of assistance with one of my spreadsheets (I am using excel 2000, and not the newest versions.)
The first three columns are typical lists, the problem comes next. I need these to remain unlocked.
I have a working validation list in Column D that has 3 items that for each row one must be chosen.
Based on this choice I need corresponding cell in that row unlocked, and the others to remain locked. Example in Column D, we choose Choice1 I need E,F and G unlocked and H, and I locked.
Situation 2, Choice 3 I need E, F and G Locked with H and I unlocked.
If any of you guys can help me with this I would be greatly indebted.
