#excel10tutorial

How to lock cell based on date in excel or how to protect cell based on date?

In this tutorial I am using Microsoft Excel 2010. Let’s get started. To protect cell based on date you need to follow the steps below. 

Open a workbook on Microsoft Excel 2010 

Right click on “Sheet 1” from the down left corner. 

Click on “view code” to open VBA editor. 

Write code (For your convenience I posted the code in the comment below) 

Click save and save the workbook in “Excel Macro-enabled workbook” which is “XLSM” format. Let’s understand the code for in-depth knowledge. 

 At the 3rd &  6th line you will find “A”. This is the column name where we listed date. You can change it if your sheet contains date on another column. 

 At the 4th & 7th line you will see “123456” which is the password and again you can change it according to your need. 

 At the 5th line you’ll see the message that will be displayed if you click any cell other than today’s date row. 

And Its nicely Done. 

Please subscribe because this means a lot to me. If you find this excel tutorial useful please give a thumbs up and share with your friends. 

 Please subscribe: https://goo.gl/uL8fqQ  

If you need any specific tutorials please request it here: https://goo.gl/jM78fA

Here goes the PDF tutorial for you as promised. PDF Tutorial : https://goo.gl/vYhYXM