lock all cells before current date (Dates are in Column)
Book1.xlsx
Hi,
Please help me with some VBA Coding to automatically lock cells D2:L15 if the date matches with the system date. I have attached the file. If there is any other way instead of using VBA coding that will do.
It is a little urgent please help me out.
Thank you.
Regards,
Sanoj.
Last edited by Sanoj; 03-07-2012 at 10:53 AM.
Hi. welcome to the forum
Which date? You mean today??.....if the date matches with the system date
Which is the system date??
One possible way(with "system date", in o1), is this.
Data>>vALIDATION>>custom>> =TODAY()=O1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Actually I want the date on task bar Right hand side bottom check the date with A column and if the date is past current date should lock the cells D2:L15.
...Sorry. I can not follow you...
I mean the date on column A should check the date and if its past current date should lock D2:L15.
..So try this
Highlight the range
=TODAY()<$A2
Thanks for your help, But this is not locking the cell exactly as we can delete and pasted data in past date cells.
Last edited by Sanoj; 03-07-2012 at 01:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks