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.
Bookmarks