Locking Cell Dependent on Data Entered

[Ryusui]

Hey all,

I have gotten some assistance previously from a couple of awesome individuals in getting as far as I have, but am still having some issues with my code.

I'm working in MS Office Excel 2003. I have a spreadsheet with numerous drop down boxes and references to named ranges. Here's my current quandary:
In cell I12, I have a drop down box with listed choices A, B, C and D. In cells I15, I18, I21 and I24, I also have drop downs. What I'm trying to do is when choice D is picked from I12 it locks cells I15, I18, I21 and I24 so that the choices in the drop down cannot be picked. Also, a popup message is displayed.
I was able to receive help in getting this pretty much taken care of. But the problem I'm having with the code is that the popup message is also being displayed whenever I make a choice from other drop down boxes. So if I choose option D from I12, it locks the other 4 cells and displays the message just fine, but then if I choose anything else from say K12 or L21 then the message continues to come up. Here's what I have...

Please Login or Register  to view this content.

Anyone able to help me decipher this? Thanks!

[Cheeky Charlie]

It doesn't really make sense without context, but this limits the macro only to fire when L12 is changed.

Please Login or Register  to view this content.

Post more info if this is not what you need.

CC

[Ryusui]

Nope, that worked beautifully! Thank you!

New spin on that same question:
In multiple cells (specifically L5:O5, L12:O12, L15:O15, L18:O18, L21:O21 and L24:O24) I have drop down boxes that all have the same choices. Let's say choices A-J...whatever. Is there one code I can use to make the same message box appear each time choice A is chosen from any of these boxes? Or do I have to post that whole code for each and every independant cell?

Oh yea, is there a way to either stop the message popup "The cell or chart you are trying to change..." or change it to read something else whenever someone tries to access one of the locked cells?

Thanks for all your help so far!

[Ryusui]

Bumping for aid. Thanks!

[Ryusui]

One last bump.

[Cheeky Charlie]

Sorry, your question doesn't make sense to me, but you should start new threads for any new questions.

CC