I would like to limit a workbook to a certain number of instances of opening. To make a so-called trial version that only allows it to open say 20 times, then not allow it to open again until a password allows it to open or just deletes the file. Thanks for any input

Any code based solution can be easily defeated by disabling macros when the
workbook is opened.

If you put your code and major elements of you project in an addin, you
might have more success with that approach. then it is just a matter of
maintaining a count of how many times the workbook has been opened. Of
course, the user could use windows to copy the file before they ever open
it, then start using the copy for an additional 20 times and so forth.
Also, there are plenty of password crackers out there, so any password
protection could be broken as well.

--
Regards,
Tom Ogilvy


Denny Emery wrote in message
...
I would like to limit a workbook to a certain number of instances of
opening. To make a so-called trial version that only allows it to open say
20 times, then not allow it to open again until a password allows it to open
or just deletes the file. Thanks for any input

Thanks for the help