Time limited spreadsheet

[eti3nne]

Is it possible to set some sort of time/date limitation on a spreadsheet, after which time access would be barred (unless a password is entered to restart the period)?

Thanks for looking....

 

[SkipVought]

Yes.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Gavona]

How about using the Workbook_Open() event to hide all worksheets, then check the date against a value stored in a very hidden sheet.

If date has not past then unhide the relevant sheets.

If date has past then an inputbox could invite entry of a password that is checked against value stored in a very hidden worksheet.....Invalid password closes the workbook.

If this is not secure enough for you then the workbook could simply close if the date is expired UNLESS a specific environment variable is found (?username?)or a second password protected workbook is open. In this case you would need to ensure that the workbook_save event hid all the worksheets (veryhidden). Also this type of security can be defeated if someone disables VBA from running






Gavin

 

[macropod]

Hi Gavin,

It would probably be better to use the Workbook_Open() event to unhide all worksheets if the 'use-by' date hasn't passed and the to Workbook_Close() event to hide (xlVeryHidden) all worksheets. That way, the user has to enable macros for anything to happen.

eti3nne: Do note that any measures you take to secure a workbook, short of using a compiler, can be easily circumvented.


Cheers
[MS MVP - Word]