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