Automatically Protect/lock Worksheet In 24 Hours

  • Thread starter Thread starter ian.emmanuel
  • Start date Start date
I

ian.emmanuel

I'm preparing an Technology downtime tracker in which the Managers
have to put in details of the time dueto which they were un-
productive....the file will remain open for for 24 hrs for each day,
and after that, post 24 hrs...the file will be automatically locked
showing some error msg like "Time Over For Changes" etc....this will
continueuntil n unless i allow changes to be made after 24 hrs...kinna
ADMIN access to the entire sheet.........
 
Hi,

You will need to use VBA if you want it to be automatic. Take a look at the
OnTime command in the VBA area.
 
Back
Top