How to enable locking a cell automatically after certain date

**rao.gnaneswara** · 10-11-2012, 01:14 AM

I am not sure, is there any old thread in regard to this feature of excel. (I could not find one). Can any body help me out for this.

How to enable locking a cell automatically after a certain date?

for example, cell a2 I have entered some data "3000Ltrs", and a date "1 Aug 2012" entered in a3. I want the 'A2' cell to get locked after 30days from date entered in "A3"(ie 31 Aug 2012), so that the user will not be able to alter the data in 'A2' without Changing "A3".

**Sindhus** · 10-11-2012, 01:56 AM

Hi, You can try this code. You need to protect the sheet, for the locking to take effect.

Please Login or Register  to view this content.

**Winon** · 10-11-2012, 02:33 AM

Hello rao.gnaneswara,

Welcome to the Forum.

The attached WorkBook demonstrates how it can be done.

Also see the "Please consider" note at the bottom of this post.