Excel File Expiry Coding with Renew Option

Dear Forum Experts,

I have been trying to develop VBA Coding for File Expiry which allows the user to Renew by inputting the password by "user form" for every 8 Months otherwise file should be closed.

Here I attached sample file which contains VBA Coding to Check expiry date and closes the file immediately, I want to upgrade the coding as above.


Thank you...

Dear Forum Experts,

Any Update Please...

See the attached file which I think does what you're asking for.

This goes in the Workbook_Open() event - there are two commented out lines which you should uncomment in the real code so that users cannot unhide the sheet that contains the expiry date and password.

Please Login or Register  to view this content.

And this goes in the form object:

Please Login or Register  to view this content.

Hope that helps. MM.

Thank you,,,


its working......

Yes but most people don't code to get around all the tricks a user might try ... if someone really wants to break it, they will.

@ Arshad - if you want to get around this issue, then just call the code at the start of the main code; you can declare a global variable (like "booChecked") as Boolean so you only run it once. Or just leave it if you think your users are not malicious.

Yes I'm aware ... my view stands though - for normal purposes, I don't think it's worth coding for purposeful evasion of functionality.

If you save your worksheets as very hidden

Then use your macro to unhide them

Then your worksheets cannot be viewed if Macros are disabled.

yep - as in the code I provided :-)