Forum Discussion
Lock Cells If Its not Updated Today
You could also do this without VBA. With the help of validity rules, it is possible to lock one or more cells under certain conditions, so that no arbitrary data can be entered there.
Highlight the cell or range of cells
Ribbon click Data Validation,
Command data validation...
In the Data Validation dialog box,
Tab settings:
validity criteria
in the combo box Allow: select date,
Check the Ignore empty cells checkbox
In the Formula: field, enter the formula: =TODAY()
Tab error message:
Display error message checkbox... with tick
in the combo box type: select stop
In the Title or 'Error message:' text field, enter your text, such as "Invalid date".
OK button
And so that the whole thing works:
If the cell or range of cells is not empty, or contains anything other than the current date, typing in the range of cells will be blocked and the message you specified will be displayed.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)