Hello, I am trying to find out if there is a way of protecting or preventing modification of excel cells after a predetermined deadline has elapsed. For instance in cells A1:A20 a user is expected to input his/ her initials if a task is completed by certain deadline, let's say 2:00 PM. However, if the current time is past 2:00 PM the cell range A1:A20 would automatically lock preventing the user from entering their initials in this cell range. In stead they will be required to input their initials in another range where it will be noted as being late.
Is there a function or Macro that an do this for me on the background with little to no manual intervention? Thanks for your help in advance. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
