Lock data after current date.

[mohk123]

I am new to this forum so hello to all.

I am trying to lock cells after today's date has passed so that no one can make changes to it after today's date has lapsed. This is for protective reasons so that people do not play with data and names from reserving something after using it.

Mohk

[nilem]

Hi Mohk,
maybe so (in ThisWorkbook module)

Please Login or Register  to view this content.

[mohk123]

Thanks Nilem its working fine.