Capturing Date time when system is locked & unlocked

**aravindhan_31** · 05-18-2011, 03:35 AM

Hi,

Is it possible to capture the time in excel when the system is locked & un locked
like this
Col A--------------------- Col C
Locked Date & time------ Un locked Date & time

So I will keep my excel file open always, everytime the system is locked and unlocked capture the details one after the other.

**aravindhan_31** · 06-13-2011, 06:24 AM

can someone suggest me the best way...

**arvindkrkaushik** · 12-24-2012, 08:08 AM

Hi All,

Can anybody tell, how to capture date time in Excel 2007 when system is locked or unlocked.

Many-100 thanks in advance.

Thanks,
Arvind Kaushik

**Richard Buttrey** · 12-24-2012, 10:54 AM

Hi,

What event is giving rise to the locking and unlocking? Is this some manual process or a macro that is run. In addition please explain exactly what you mean by the system being locked/unlocked. In Excel individual cells may be locked or unlocked and individual whereas sheets are protected or unprotected.