VBA novice needs help with .Locked on a sheet

[TheOldPuterMan]

Hi all,

I have a worksheet that is a daily record of scratch-off lottery tickets sold. I need to be able to restrict entry to the current day to reduce data entry errors. The sheet knows what date/day of the week it is and I set up a VBA macro to query that cell and set .Locked to false for only that day.

I protect the entire sheet at the beginning of the macro but, even though it seems to be correct, none of the cells are protected.

There are two cells defined as not Locked, in addition to the days' input. Those are a date field and a reset Yes/No

Please, any help??

TheOldPuterMan