Lock specific cells once a value is entered with a drop down list

[MissDB]

Hi,

I have a spreadsheet that is being used to book leave. There are certain cells on the worksheet that are open to the user e.g. Name, Contract type etc. Further down is the area where they request leave. So in column B is the date from (where they have to enter the date in a certain format and column C/D (these are merged due to formatting of the worksheet) contains the date to etc. At the end in column AP there is a column for the manager to make their decision (this is protected from the user like most of the other cells.

What I need is once the manager has made a decision i.e. they have selected either "Accepted", "Rejected" or "Cancelled" from the drop down and protected the workbook again the row where the decision has been made is locked. Or more specifically the cells that the person could once amend e.g. with the dates etc, is no longer editable. This will hopefully prevent someone from changing the dates after they have had it approved.

I have looked on various forums/web sites but cannot find the specific code for my purpose and I did wonder if the merged cells (as mentioned above) were causing part of the issue?! Any help is greatly appreciated!

Thanks
D

[Richard Buttrey]

Hi,

A Sheet Change event macro that detects an entry in the Manager's AP column and which then unprotects the sheet, locks all the cells on that row and then resets worksheet protection.

[MissDB]

Sorry but I am really new to coding and have no idea about to write the code for what you suggest. I understand the logic and have found some similar code on the web that I think does what you say but it didn't work.

[Richard Buttrey]

Hi,

If you'd like to upload the workbook no doubt one of us could add the solution for you.

[MissDB]

Hi,

How do I do that?

Thanks
D

[Richard Buttrey]

See the FAQ. Specifically

http://www.excelforum.com/faq.php?fa...chment_explain