"Time Bomb" - How to Stop an Excel File from Opening Past Certain Date

[AGlazer]

Question for the gurus.

We have an excel file that we want to be able to "time bomb", so that it can't be opened without a password after a certain date. The file still needs to be able to be opened (if we have the password).

We've figured out one way to do it, but it requires that the file be opened with macros "on". Is there any way to only have the file be able to open if macros are enabled?

Any suggestions would be appreciated.

Thanks,

Aaron

 

[Chattin]

One way is described loosely here:

http://j-walk.com/ss/excel/tips/tip100.htm

i.e. setting sheets to xlVeryHidden and using the Workbook_Open to unhide them etc.

An idea you could combine with your solution perhaps?

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[AGlazer]

Chris,

That might work - thanks for your help!

Aaron