Jan 4, 2020
The Visual Basic Editor - Excel VBA Programming Course: Lesson 8
seen from Lithuania
seen from Israel
seen from United States
seen from United States
seen from Malaysia
seen from Singapore
seen from India
seen from United States
seen from Poland
seen from Moldova
seen from Italy
seen from Georgia
seen from China
seen from United States
seen from Australia
seen from United States
seen from China
seen from Norway
seen from China
seen from United States
The Visual Basic Editor - Excel VBA Programming Course: Lesson 8
(via https://www.youtube.com/watch?v=QGB3Ic275to)
How to Add Prefix Using Functions In Excel
How to add suffix to a cell or data in excel using vba
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
How to Lock Cell Based on Date in Excel