allow users to edit ranges

The attached file has been shared with my colluges, now they are having access to edit the ranges for all the dates and it was protected with unique password for each and every bay.

Some times they are editing the values for the completed dates, now i need to protect them for the dates which has been completed and they should be allowed only to modify the datas only for today and yesterday, for that i need vba prcedure to prevent the access.

Please help me to solve this issue, and many thanks in advance for all your efforts.

Thanks & Regards
Muralidaran.

Hi

You need to do this only with VBA?

Because you can do this, using Custom Format..

Highlight the area that you want to use the Custom Validation.

Then >>Data>>Validation>Custom. Put this formula.

=OR($C3=TODAY,$C3=T0DAY()-1)

This validation, allows to users to modify anything, ONLY in the columns that Header date =Today or Yesterday.

I made for you range c4:j9. Same for the others.

Hope to helps you.

You are welcome!

Thanks for the reb*