Delete Macro Forever

I've made a macro program, and I've kept password on it. Is there any code/ way to delete the whole macro/ modules on a fixed date or time?

for example - If I want to keep alive my macro program just for next 100 days, then is there any code, which I can put in a module to destroy/disable the program automatically after 100 days?

If it can happen, then there should be a message too, which can tell abt the program is going to be delete after 3 days, then 2 days, then 1 day ....and later nothing to see and run there.

Hello SunOffice024,

This macro will remove all macros in the workbook, including itself. Now you just need some code to detect if 100 days have passed since it was installed.

Please Login or Register  to view this content.

Hi Leith
Is there any way to run the code with VBA protection or a way to open VBA modules with know password from with in?

Leith I think I've got it with sendkeys and searching

Mr Pike...but I don't.

Hello SunOffice024,

What do you have password protected: Workbook, Worksheet, or VBA Project?

Rob: SendKeys is not very reliable for initiating actions. Unfortunately, VBA doesn't have a built-in method or property to supply the VBA Project password to active project. However, I do know of another method, but it violates the forum rules regarding security so that isn't an option.

No, plz don't take it wrong!

I mean that I've made a macro enabled project in ms excel, now wht I want to do that - to secure my codes & idea, I would keep the VBA protection in on.
..but one more thing I would like to add in my project that my project will run just for a particular day/ date. After tht day/ date the whole VBA project must be disabled/ destroyed forever, and before deleting my codes one/user can get a notification message, for example - this VBA project will be no longer after this date. This is how my project will be useful for a limited time.

I hope u'd have got me by the above posts & examples!

Hello SunOffice024,

I will need to test some ideas for setting a limit on the days. Not sure if the code will delete the macros if the VBA project is protected. Seems to me that should not be a problem since the macro is already in the project. Best not to assume.

Hello SunOffice024,

I believe that is true. Since I have never done this with the project protected, it will need to tested to be sure it works.

How about using the c drive temp folder to store a text file.The file is created and dated the file was first opened

On second third opening it checks to see if the file exist and if not creates one with time stamp.if yes it reads the date and deletes after 15 days ect...

everyone has a temp file and I use it to store text file when work with other application

As long as the user will be able to turn off macro execution, he/she will be able to modify the VBA-code to prevent any code deletion at a certain moment.

snb is right there is no point because users can open the module and change the delete code.. better off having an expiry date in the code so if the date in the code is pasted it dosent work.