expire workbook

  • Thread starter Thread starter alldreams
  • Start date Start date
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
 
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 :-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1
Excel Protection 2
expiry date for passwords 1
Delete All Q 6
Expiration notification 4
create log in using username/password... 1
Procedure to update a DATE field to either a year from now or a year from what is in the field? 7

Back
Top