ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Destroy VBA code within a macro (https://www.excelbanter.com/excel-programming/436586-destroy-vba-code-within-macro.html)

omer

Destroy VBA code within a macro
 
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

Destroy VBA code within a macro
 
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
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



mrkt_rwnd

Destroy VBA code within a macro
 
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

Destroy VBA code within a macro
 
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
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


.


omer

Destroy VBA code within a macro
 
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
.



All times are GMT +1. The time now is 01:46 PM.

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