VBA to run a max of once a day

[shophoney]

Hi, I'm looking to have an excel file in my windows startup group and have it run when windows loads.

But I would like to have the code ONLY run once a day.

So if the code has already run today don't run it again till it's loaded tomorrow.

I can add a Power Pivot calculated column and have it list last refresh. Would that help?

Thanks

 

[shg]

The code could create a named formula contain the last run date, and not run again until that date passes.

 

[kimkamp]

I like to use a hidden 'Settings' tab with this kind of info. I save the current date to a row in this hidden tab the first time the Workbook is open that day, and read the value into a Global variable each time the Workbook opens, to see if I need to run the daily routine again.