AUTOMATICALLY LOCK CELLS W/N GIVEN DATE

[Business Analyst JM]

Pls help me in my codes in excel,

This would be the condition,

I have a form? Then in column "B"? they have to set a date then "IF the Date is less than the current week? the whole Row must be UN-EDITABLE" and is protected by a Password...

Ex. Today is 05/11/2017? all previous week will be un-editable starting 5/6/2017 and below? and can I also set a date? when it will be uneditable?...example every Monday? All previous dates will be uneditable except if the password was inputed?

Thank you So Much

 

[vletm]

Business Analyst JM
You have a form ... so?
Protected ... do You mean 'normally' protecting workbook with password?
that would be interesting ... the whole row ... and so on.

Would You test something like this?
B-col has dates,
if You make unwanted row select then 'activecell' jumps to [A1],
if You want to 'disable protection' then activate cell[AA1] and
write Your Chandoo username for password,
if correct password then [B1] will be 'red',
reactivating [AA1] enables protection.
> Ideas .. questions .. answers?

 

[Business Analyst JM]

Good PM Sir,

Pls see att file for the sample form that i had mention earlier in the post, base on this DAR - (Daily Activity Report) they need to fill up the necessary column details each row and what's important is that after a week? every Tuesday? The previous dates' row will be locked as i explained in my post to keep them from altering the data they inputted since we will monitor it...pls help me...

Thanks and very much appreciate your response Sir


Best Regards,
JM

 

[vletm]

Business Analyst JM
... no answers, about no form! ...
... no answers, about 'protection' ...
There are some ActiveX-components for some use (I cannot use!)
which pop-ups almost everywhere.
Did You even test my file from Your original ... a little different sample file?
I should do as You wanted ...
what is missing?

 

[Business Analyst JM]

Hello Sir,

What is the Password for the filr that you sent sir? is it "Business Analyst JM"...including caps & spaces?

Thankyou So Much Best Regards,
JM

 

[Business Analyst JM]

Hello Sir,

I'm trying to input the code but I have this error



Best Regards,
JM

 

[vletm]

Business Analyst JM
> Password ... as I wrote as You wrote, maybe You know Your username.
> 'Error' is You have two or more times same named Sub then You'll get that 'message' - it's is normal for this case - use just ONE 'Worksheet_SelectionChange'.

 

[Business Analyst JM]

Hello Sir Good Day,

How will I do it?, should I copy your code after the 1st 'Worksheet_SelectionChange'?...something like the picture below?

but then it seems having an error..

Thankyou Very Much for your Patience Sir Very Much appreciate it, I'm very sorry also for my Idiocy I'm just having a hard time figuring out.


Best Regards,
JM

 

[vletm]

Business Analyst JM - hmmm ... what to try to write?
Copy & Paste do not always make the best result.
Because only new questions,
I gotta try to figure Your code ...
and ...
Maybe those tried to protect sheets validations ...
so
I add few lines to my code.
Now, it would be more challenge to delete those.
There are also some 'messages'
if someone try to some unwanted clicks.
Ps. I left 'Your old code' ... but those do not work just now!