Cell Locked or Unlocked depending on another CELL value

[MYEM1983]

Dear All,

I'm trying as below:

If F3 contains specific word i.e. FCL then only cell K3 and L3 are unlocked or available for data input.

Additional information:
F3:F10002 contain data validation list
I need to apply above condition on K3:K10002 and L3:L10002

I did some search on this forum and I came to know above can only achieve through VBA only. Is there is any possible way without VBA? I'm not good with VBA etc therefore your assistance will be highly appreciated.

Thanks in advance!!

Regards,
MYEM

[hemesh]

I think you need to go only with VBA Solution.

[MYEM1983]

Can you please also advise what to be done to achieve above??

[hemesh]

so you want to unlock the Cell K3,k4,k5 up to K10002 if F3,f4,f5 up to F10002 contains word "FCL" or you want to unlock K2 to K10002 if only F3 Contains Word "FCL"

[AlphaFrog]

• Right-click on the sheet tab
• Select View Code from the pop-up context menu
• Paste the code below in the VBA edit window
• Change the password "Secret" to suit.

Please Login or Register  to view this content.

[288enzo]

Sorry for digging up an old post but it came up in my search, and I just need a little help tweaking it. I'd like to unlock E21 based on "Override" being selected via a drop down validation in E20. Thanks for the help.

[MYEM1983]

Sorry for replying late..... and thanks to AlphaFrog for providing me VBA code but dose not seem to be working what I want!

This sheet will be filled by my team mates and I cannot go to them everytime inserting passwords. I would like you to advise me VBA code without password protection for following:

If in F3:F10002 text FCL is mentioned then only K3:K10002 and L3:L10002 are available for number entry if F3:F10002 contains anything else then K3:K10002 & L3:L10002 do not accept any entry or remain locked.

Appreciate your help and time on above query.

Thanks!

[MYEM1983]

Hello Everyone!!

thanks for your time and input I've achieved my required thing without VBA

I'll share my little knowledge with all you PRO's just incase if it could be helpful to you if you come across the same situation. My question was as below:

If F3:F10002 any cell contain FCL then corresponding K3:K10002 and L3:L10002 allow input otherwise they do not accept any input or remain lock for input.

Solution which I did is as below:

I went to K3 and used DATA VALIDATION > Custom > and then input formula as =IF($F3="FCL",INT($K3),0)

Similarly I used DATA VALIDATION > Custom > and then input formula as =IF($F3="FCL",INT($L3),0)

And solved my problem

Thanks to all folks!!