Locked worksheet based upon date and locked columns when worksheet is not locked

My apologies. I must have missed that. I have updated the post. Thank you in advance.

Not a problem,

Here is a test book,see if it works for you.
Thank You, Mike

It appears to work except the April and May sheets should be ulocked now because it is prior to the 7th of May and therefore April would still be open. After the 7th of the month it would lock the previous months worksheet and only allow you to edit the current months sheet.

By the way, thanks. This is great.

Here is a new version to try:

This will keep all the worksheet protected at all times:

If the worksheet is in the current Month the user will be able to input data for the ranges you specified.
or
if the date is within 7 days or less in the current month worksheet, the previous months worksheet will be able to let the user input data.

However Columns "E,H,K,L" the user will not be able to edit.

Let me know how it works out.

Thank You, Mike

This appears as if this works. Thanks for your help. This is great.

Thank you,

Jarrod

Should I be able to unprotect a sheet (by right clicking on the worksheet and clicking uprotect sheet) without entering a password? The code looks like it is using a password, but it allows me to unlock without a password.

Hi,
My Bad...

This should do the trick:

Mike