I am the new learner of Excel VBA and I have searching many VBA Stuff's from our forum.
My Requirement for this new thread is Lock the cell Column D based on the drop down selection in Column C.
Please find the attached file for your reference. I would like to explain my requirement with more details.
This attached excel file having some header Std.No(Column A),Std.Name(Column B),Pass/Fails(Column C) and Remarks(Column D).
Column C (Pass/Fail) having drop down list Yes/No.
If i select in column C value as "Yes" then particular Column D cell only locked automatically except to lock the whole sheet.
For example: Column C2 value is Yes - Then lock the cell value only D2 and shade by some color. But, It should be editable for other cell values A2 and B2,C2.
If i select in column C value as "No" then particular Column D cell is free text for giving some remarks.
Immediate replys are very much appreciated.