Data Entry into Cell Range between 2 specific date periods and to lock after a specific date

[rpra137]

Hi Everyone!
I'm new to VBA, but I have a number of ranges, which I only want to be editable between specific dates.

I.E. Data range should be editable between 01/01/2024 to 01/03/2024. After 30/01/2024, the range should be locked preventing any further amended or changes. I have to repeat this 12 times across 12 ranges for different dates, the next being editable between 01/02/2024 to 01/03/2024, and being locked on 30/02/2024.

I've looked into ways of doing this and realise that probably VBA is the best option - but I can't seem to work out the best to code this!

 

[kevin9999]

Data range should be editable between 01/01/2024 to 01/03/2024. After 30/01/2024, the range should be locked

That's contradictory. Editable between 1st January and 1st March - but locked after the 31st January?!
Also, what day of the week does "30/02/2024" fall on?

What you're asking for is achievable with worksheet activate event code, but you're going to have to be a lot clearer with your expectations.