Calendar expiry

[MissK2018]

Hi There,

I've been searching and I can quite figure this one out. I don't work with calendars/dates all that much so perhaps it's an easy answer

I have a work book with a series of worksheets. Each worksheet represents a 4 week period.

I'd like to, if possible, insert a function on each work sheet that would, in essense, expire/lock that worksheet if the date doesn't meet the date range on the worksheet.

Thanks in advance for your help!

 

[6StringJazzer]

expire/lock that worksheet if the date doesn't meet the date range

What date?

 

[MissK2018]

What date?

The date would be specific to the worksheet.

For example: WOrksheet A would run from Jan 1 - 16th. I would only want that worksheet to be avail to edit/enter until say Jan 20th. Then I want it to lock and basically force someone to use the next worksheet in teh work book (I guess then simultanously I woudln't want the next worksheet dated Jan 17 - Feb 3 to be availabl until Jan 17.

I hope this makes sense.

Thanks for your help !