Hello
I wonder if somebody know a way to delete some macros/code from within a
macro when a trial period has expired, so that the VBAProject is useless
after that period. I already have the trial period implemented, but want to
enforce the users to ask for a news version.

Thank you for your help
OMER

OMER

See Chip Pearson's site for a timebomb workbook.

http://www.cpearson.com/excel/workbooktimebomb.aspx

Read carefully the caveats at the beginning and alternatives to VBA


Gord Dibben MS Excel MVP

On Tue, 24 Nov 2009 10:28:02 -0800, OMER <(E-Mail Removed)>
wrote:

>Hello
>I wonder if somebody know a way to delete some macros/code from within a
>macro when a trial period has expired, so that the VBAProject is useless
>after that period. I already have the trial period implemented, but want to
>enforce the users to ask for a news version.
>
>Thank you for your help
>OMER

How about a date check that exits the routine if it is surpassed? You
could also put one in at the workbook open level to close the file the
moment it was opened. You may want to run a modal window/message box
letting them know they can buy it and where. Cheers

Thank You Gord for the link.
Great ideas there.
Regards,
OMER

"Gord Dibben" wrote:

> OMER
>
> See Chip Pearson's site for a timebomb workbook.
>
> http://www.cpearson.com/excel/workbooktimebomb.aspx
>
> Read carefully the caveats at the beginning and alternatives to VBA
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 24 Nov 2009 10:28:02 -0800, OMER <(E-Mail Removed)>
> wrote:
>
> >Hello
> >I wonder if somebody know a way to delete some macros/code from within a
> >macro when a trial period has expired, so that the VBAProject is useless
> >after that period. I already have the trial period implemented, but want to
> >enforce the users to ask for a news version.
> >
> >Thank you for your help
> >OMER
>
> .
>

Thank you mrkt_rwnd.
I have a similar mechanism implemented, but wanted to disable the code
completely.

"mrkt_rwnd" wrote:

> How about a date check that exits the routine if it is surpassed? You
> could also put one in at the workbook open level to close the file the
> moment it was opened. You may want to run a modal window/message box
> letting them know they can buy it and where. Cheers
> .
>

Try:

http://www.ozgrid.com/VBA/delete-module.htm

http://vbadud.blogspot.com/2007/05/d...using-vba.html

http://support.microsoft.com/kb/172109

http://www.cpearson.com/excel/vbe.aspx

So one module sub would implement one of the routines above on a
separate module, then resave the workbook.

Best, J