Help with locking a cell if another cell contains certain text

[kfryar]

Hi all,

I have a sales pricing model and i need to lock access to a cell if another cell contains certain text.

If C7 = "Existing Client" then F14 is editable
If C7 = "Prospective Client" then F14 is not-editable

Any help would be much appreciated!

[TMS]

One way:

Please Login or Register  to view this content.

Regards, TMS

[kfryar]

Thank you for that, but I can't seem to get it to work... I am a novice when it comes to macros so bear with me.

Do I need to protect or unprotect the cell or worksheet when running this? Should I save and close before it starts working?

[TMS]

Right click on the tab which you want to protect and select View Code. Copy and paste the code into the code pane. Then switch back to Excel and test whether or not you can select the cell.

Regards, TMS

[kfryar]

Amazing! Thank so much!!!!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.