Hello,
You try putting
declare dtexpire as date
let dtexpire = 'your macro expiry date'
if dtexpire < = date then
your macro code here
else
msgbox "macro date expired contact developer"
endif
Regards,
Sarfaraz Ahmed
http://findsarfaraz.blogspot.com
On Sun, Mar 8, 2009 at 10:10 AM, Aindril De <[email protected]> wrote:
> Hi Mahesh,
>
> Please go through the following link. This should take care of your
> problem:
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=475
>
> Regards,
> Aindril
>
> On Sun, Mar 8, 2009 at 7:50 AM, Ashish Jain <[email protected]> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: mahesh parab <[email protected]>
>> Date: Sat, Mar 7, 2009 at 9:24 PM
>> Subject: Creating Expiary Date for Macro or VB Script
>> To: [email protected]
>>
>>
>> Hi Ashish
>>
>> I have created a VB Excel sheet & i want to put expiary date.
>> Is it possible that after certain days Macros will get disable
>> automatically
>> if yes then what will be script?
>>
>>
>>
>>
>>
>
> >
>
--
Thanks with regards,
Sarfaraz Ahmed
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
