ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Limiting number of instances of a workbook (https://www.excelbanter.com/excel-programming/288290-limiting-number-instances-workbook.html)

Denny Emery

Limiting number of instances of a workbook
 
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

Tom Ogilvy

Limiting number of instances of a workbook
 
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



Denny Emery

Limiting number of instances of a workbook
 
Thanks for the help


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com