Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default 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


.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default 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
.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search & Destroy Ben H Excel Programming 2 July 26th 06 06:57 PM
Search and destroy Pugwyrm Excel Programming 4 February 14th 05 03:13 PM
Destroy command button with a Macro? grasping@straws Excel Discussion (Misc queries) 3 December 22nd 04 02:30 PM
How to make VBA code to self-destroy itself? count Excel Programming 6 November 10th 04 05:11 PM
Seek and destroy [email protected] Excel Programming 7 December 3rd 03 08:41 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"