Auto locking of sheet by date

[TheRetroChief]

Greetings folks,
Just wondering if there is way by which i can get a sheet to automatically lock depending on the current date. Most of my sheets have the current date in them. I need them to lock off on a certain date as I am often not there on the day to do it myself. I have had several occasions where people have gone in and changed figures after i have sent reports off. Not good.
Cheers,
TRC

[Palmetto]

It can be done, but it is not a secure way to prevent tampering due to the fact that

A. You must use VBA code to do this
B. Users can choose to not enable macros thereby defeating the protection

By default, all cells have their locked property turned on. You might be better served by unlocking only the cells where edits are permitted and then apply sheet protection with a password so that locked cells cannot be changed.