Change code so macro activates when entry date is older or equal to current date

Thank you for taking a look at my issue.

A very kind Forum Guru named xladept helped me develop the following code that works beautifully:

Please Login or Register  to view this content.

Unfortunately, I have discovered a small, but serious, design flaw in this code. If the person in our office responsible for the Excel data entry is out sick, the spreadsheet is not opened that day or days, so the formulas that the code 'freezes' stay as formulas. As a result, when that person comes back into the office and opens the Excel file, the code will activate, but only for whatever day is current. All the days missed are left behind with intact formulas which creates a problem down the road.

I need to change the code from a logic of "if D equals current date, then activate" to "if D is older or equals current date, then activate". This way when the data entry person comes back in the office and opens the Excel file, the macro will 'freeze' all the effected formulas that were missed.

Hopefully I've described the issue satisfactorily.

Thank you ahead of time for any assistance.

Thanks guys.

I kinda figured that changing the "=" to "<=" would do it, but since my code skills are very rudimentary, I figured I'd better check-in with the experts to make sure.

I'll make the changes and see what happens in the morning.

Thanks again for your help!