expire workbook

A

alldreams

Hi all,

How would I set a workbook to expire after say 3 months
so the user wouldn't be able to open it ever gain?

Thanks for your help
 
F

Frank Kabel

Hi
not really possible with Excel. You may put some code in the
Workbook_Open event to check for the current date. Also hide all your
sheets and protext the workbook/VBA project
Make them visible in the workbook_open event to prevent users from
simply disabling macros.

But this is not bullet-proff. A determined user simply cracks your
passwords and changes the code.Another idea would be to create a COM
Add-in, do the checking within this Addin. But this Add-in has to be a
central part of your workbook :)
 
Top