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...