Hi Everyone,

Am a novice when it comes to VB so appreciate any help I can get.

I am trying to lock down a cell after it has been updated. However, I would like the remainder of the sheet to remain editable and not locked down.

For example;

I have columns A through E and G through I that I would like to retain the functionality for users to update if\as required as these fields require regular changes. Cells within Column F however (date entry) should be locked down after the initial input has been entered and can only be unlocked with a password.

I would also like to have a pop up box to highlight to the user that they will only have the opportunity to update this field within column F once, so would like to have them Confirm if the information is correct Y\N before committing.

Thanks in advance to the forum and appreciate any help anyone can provide on a VB script I can add to my worksheet to perform this functionality.

Cheers.