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
?