Locking cells / rows after a specific date

[mr_ordinaryboy]

dear all,

I'm currently stuck with Excel and I hope you guys can help me.
I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed.
This date will be defined in D3-O6.
So the way it should work is as follow:
For Jan: Once the date in D3 has passed, then all cell the forecast quantity in D6, D9, D12, ... , D24 will be locked and no changes can be made again.
For Feb: Once the date in E3 has passed, then all cell the forecast quantity in E6, E9, E12, ... , E24 will be locked and no changes can be made again.
For March - Dec would be the same as above.

Other cells or rows like D7,D8,etc should be still editable.

Can someone help me with this? I think I might need Excel VBA but I'm just a newbie in this area.

Thank you very much in advance for all the help and support.

BR,

 

[Marc L]

Hi, you must first unlock manually all editable cells.​

Once a date has passed then your VBA procedure must unprotect the worksheet, lock the cells then protect the worksheet …​

​

 

[mr_ordinaryboy]

Hey Marc,

thanks for your reply.
I have unlock all the editable cells.
as for the VBA, any help/guidance how to do so? I'm still very new in VBA and have unfortunately little to no experience in writing it

 

[vletm]

Are those the forecast quantities values or formulas?

 

[Marc L]

as for the VBA, any help/guidance how to do so? I'm still very new in VBA and have unfortunately little to no experience in writing it

As it depends on what we can't see, missing informations, I have no experience in mind reading …​

​

 

[mr_ordinaryboy]

Are those the forecast quantities values or formulas?

the forecast quantities are values

 

[mr_ordinaryboy]

As it depends on what we can't see, missing informations, I have no experience in mind reading …​

​

could you please give me guidance where I can start?

 

[vletm]

mr_ordinaryboy​

Do this sample work as You've written?

 

[Marc L]

where I can start?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org