Lock cells after Today's date passed (VBA excel code)

Hello all,

I am trying to lock cells after today's date has passed so that no one can make changes to it after today's date has lapsed. This is for protective reasons so that people do not remove their names from reserving something after using it. Now the code should disallow locking after cell input entry when today's date hasn't passed so that changes can still be made by the user. I am trying to determine the code to do this but I have no idea as to how to do it.

Here's a scenario: I reserve something for Aprill 15, 2009. I input my name. Since it's April 13th, 2009, I am still able to make changes up and until April 15, 2009. After this date, the cell is locked and no changes can be made, except for the administrator.

I want to automatically lock all cells from (D7:J7675) prior to today's date (not including today's date) so that no changes can be made unless you have administrative privileges. This is to protect the integrity of the reservation so that when the reserved thing has been used, the user cannot remove their name to illustrate that they did not use it.

I've attached a sample reservation schedule for reference as to what I mean.

Please advise,

Thank you all

@rt1306, did you ever find a solution? I currently am trying to code this as well. Please let me know if you've found a solution.

anyone else have ideas?

thanks in advance.

rt1306, you should have linked this post to your solved thread. it would have saved me time.

still not a solution...

http://www.excelforum.com/excel-prog...xcel-code.html

My apologies, thanks for posting the link to link the resolved one.

For further inquiries by others, please refer to the link posted above by mikron88.