Set expiry date for macros?

[AlexandarRamaiyan]

Hi All!

Greetings!

I have an Excel workbook which contains some macros.

Those macros should be able to run until 1st November 2010 (or some date). After that, when we try to run any macro, it should display some customized message! If I need, the date have to be changed within the code.

Is it possible? Please HELP!!!

[pike]

hi AlexandarRamaiyan
some thing like....

Please Login or Register  to view this content.

[Alf]

Or perhaps something like this.

Please Login or Register  to view this content.

Name the modul with the "forbidden" macro "My_macro"

You may have to set a referense to “Microsoft Visual Basic for Applications Extensibility"
Tools -> Macro -> Visual Basic Editor -> Tools -> References

If there is a problem with access to VBA project see this link. http://support.microsoft.com/kb/282830

This macro removes the module with the "expired macro" and then saves the file so it replaces your original file.

[AlexandarRamaiyan]

Thanks a lot!!!

[snb]

Or

Please Login or Register  to view this content.

[Alf]

Hi snb,

Did you test your macro? When I run it I get the error message "compiler error: Type mismatch"

[snb]

no big deal:

Please Login or Register  to view this content.

[AlexandarRamaiyan]

no big deal:

Please Login or Register  to view this content.

Thanks a lot to all! It works fine!

[excelcraze]

Or

Please Login or Register  to view this content.

I came here in search of a macro that will set an expiry (or some tricks to disable) for macro.
I use this code it worked. However when I read it I thought it would delete the macro and when I reopen the file it wouldn't be there or won't work. When I reopen the file it's still there and when I changed the system time it is still working. How can we make a macro that will not work even if you change your system time?


Thank you.

[arlu1201]

excelcraze,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

[excelcraze]

I am sorry if i break your forum rules if any. However, when I googled for an expiry macro I got this link and that's how I am here which I clearly mentioned in my post. I thought I got what I came here for, and the same didn't work how I thought I would, so I thought I better ask in the same thread where I could get reply from same person who provided that macro rather than creating a new thread and ask others. Am I wrong dear admin?

[arlu1201]

This thread is about 3 yrs old and its not likely the users will come back to an old thread. However, if you open a new thread, you can get faster replies. Hence, i asked you to open a new thread for your question.

[excelcraze]

Ah I like that reply . Anyway to my question (macro for expiry date) I now have an idea and I think it should work perfectly. Let me try it tomorrow at office. If it's not I will start a new thread.

Thank you