View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default auto locking of excell workbook (excell 2003)

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


On Fri, 14 Nov 2008 14:07:01 -0800, cheekymonkey
wrote:


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
?