auto locking of excell workbook (excell 2003)

  • Thread starter Thread starter cheekymonkey
  • Start date Start date
C

cheekymonkey

have an excell workbook, it contains sensitive information due to the nature
of the company/job etc. Upon opening these workbooks , if unused after a
short time can they be locked auto matically requiring a pass word to re open
?
 
Hi,

Apologies but I find it slightly amusing that a sensitive workbook should be
left open and unattended but here we are. By far the safest solutions and in
order are:-

1. Make the users have the self discipline to close the password protected
workbook.

2. Close the workstation using the screensaver with password to unlock.

3. use the code here

http://www.ozgrid.com/forum/showthread.php?t=32949

Mike
 
If the data is that sensitive, why not require a password to open to start
with?

But to answer your question.............yes it can be done.

See Chip Pearson's site for the OnTime method.

http://www.cpearson.com/excel/OnTime.aspx

Just remember there are password crackers available out there.


Gord Dibben MS Excel MVP
 
Back
Top