Below is what I am using to protect my program I wrote but I know all they have to do is change the computer's date and it will work. Is there a way to protect from that?
![]()
Please Login or Register to view this content.
Below is what I am using to protect my program I wrote but I know all they have to do is change the computer's date and it will work. Is there a way to protect from that?
![]()
Please Login or Register to view this content.
Last edited by Leith Ross; 10-21-2014 at 05:30 PM. Reason: Fixed Code tags
You can write the date each time the workbook is opened to the bottom of a list on a hidden sheet. If the current date is less than the last date written, ...
Entia non sunt multiplicanda sine necessitate
From a practical point of view, all they need to do is not enable macros. Then your workbook is open and exposed for forensic examination. Most Excel protection will only be effective against people with limited experience and awareness of Excel's capabilities.
Do you have mechanisms in place such that the workbook is of no practical use unless macros are enabled? Is your VBA Project password protected and locked for viewing? Are the worksheets "very" hidden through the VBE interface, or just hidden, or not hidden at all?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks