I hope this is what you're looking.. On Sat, Jun 18, 2011 at 7:29 AM, AyaNayzgi ZeWolqait <ayanay...@gmail.com>wrote:
> 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 > -- ---------------------------------------------------------------------------------- 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
OnTime.xlsm
Description: Binary data
