Destroy VBA code within a macro

[OMER]

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

 

[Gord Dibben]

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

 

[mrkt_rwnd]

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

 

[OMER]

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

 

[OMER]

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

 

[mrkt_rwnd]

Try:

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

http://vbadud.blogspot.com/2007/05/delete-module-on-fly-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