Run a macro only once a day

Hi everyone

Got a question for the VBA fundis.......is there a way or some code that you can force a macro to ONLY run once in 24hrs....so it will execute once a day -if its run again it wont run. I was just wondering if that is possible to code in VBA.....example Have a macro called Test......the test macro can only run once a day......if its run within 24hrs again it wont execute as it already ran.

If this is possible I would appreciate a solution -rep given for you help

Many thanks

found this code

Please Login or Register  to view this content.

So if I replace the Msgbox with

Call test

Will this check it wont run again ?

Originally Posted by Keebellah

If you add a include the code to write the date to a specific cell the moment the macro is run then you first test if the date = today's date then exit else run the macro and update the cell with the date
Hope this answers your question, of course this only works if you open the Excel workbook

Thank you for your suggestion......see the code I got -I simply dont want the macro Test to run a second time -only once a day

Originally Posted by Keebellah

The code is fine but you can simplify it to this :

Please Login or Register  to view this content.

Just test if A1 = today's date, if not run the macro and then set A1 = date
so when you run it again it won't run

In Cells A1 should I place =Today(). -I ran it and it executes twice ?????So its not doing it correctly what am I missing ?

I manage to fix this



This is the code

Please Login or Register  to view this content.

After the formula is placed in the cell it did not run again