Hello,
I’m looking for a code that will not allow anyone to use the worksheet after 1 year.
Like a subscription
Thank you
Hello,
I’m looking for a code that will not allow anyone to use the worksheet after 1 year.
Like a subscription
Thank you
Last edited by X myth; 05-19-2019 at 02:30 PM. Reason: Solved.
Paste this code into the thisworkbook macro module
https://www.wikihow.com/Protect-VBA-Code
Please Login or Register to view this content.
Last edited by mehmetcik; 05-19-2019 at 10:37 AM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
something like
this will close the workbook right after it is opened if the date is more than 366 days after the creationdate of the workbookPlease Login or Register to view this content.
Cant use the workbook anymore.. most important downside, you cannot change the creation date so also not able to extend the subscription
this option is less invasive it will allow you to open and work with the file, but when you try to save it it will close without saving.Please Login or Register to view this content.
you will need to give a lot more information and maybe a sample file to build something that works for your situation.
Thank you both very much.
I think the closest one that I'm looking for is
Q. If someone copies, or saves under a different name will the creation date stay the same?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks