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

[Mumps1]

This line of code

Please Login or Register  to view this content.

at the top of you macro should be

Please Login or Register  to view this content.

I'm not sure what you are trying to do. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data.

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit any changes to your worksheet layout.


Hope this helps - please let me know how you get on.

Regards,

Greg M