Close Workbook after openning X times

[Taislin]

Hi... i need a macro that runs on opennig the workbook so it can check how may times the file was openned in that computer and then closes it after it reaches the amounted number of times. Lets say i have a file that as a Trial need it to open a maximum of 10 times. So when it opens it starts to count and when reaches 10th time openned it closes saying something like: " Your trial period has expired. Please buy the full version."

Thank you

[Moo the Dog]

I don't know the code to do it, but you could set a cell on a hidden/protected sheet that is increased by 1 each time the workbook is opened. Then, when the workbook is opened, the macro's first task is to check the value of that cell. if it is less than your limit, increase the cell value by 1, if it is over the limit then show a 'Trial Expired' message and close the workbook.

Only one problem with that method... if people disable macros from running it won't work. =)

- Moo

[HSV]

Try it ten times.

Please Login or Register  to view this content.

[Taislin]

@HSV,

Thank you very much. Worked like a charm.

Moderator's Note: As per Forum Rule #12, don't quote whole posts unless necessary-- it's just clutter...Thanks.