Run Macro once day when opened

Hi fellas, im new to the forum so thanks in advance.

I need a VBA code that will run a macro once a day no matter how many times the spreadhseet is opened. I would like to avoid having to adjust any cells manually, as the spreadhseet I am creating is going to beused not by me, but for a number of individuals.

Im a beginer in macro/VBA and still in early stages of learning this art. I have seen some threads here on the topic, but non have been able to give me the help i need.

The sheet is sheet1

The name of the macro is Mem_Ref





Any help will be deeply apprecated.

Many thanks,

Byron

This will check cell A1 to see if it has already been ran today, if not then it amends A1 to store todays date, saves the workbook and then runs the macro (obviously A1 may not be convenient for your sheet so adjust that to anywhere free.

Please Login or Register  to view this content.

Its running the macro everytime because G1 is not being completed. Best bet is to debug and see exactly what happens when G1 is meant to be set.

I've tested the Macro shared by pjwhitfield and it's working fine. The Range isn't referring to any sheet. So when you open your workbook are you actually on the same sheet? IF not retry the below code and name your sheet as appropriate

Please Login or Register  to view this content.

Thank you ever so much fellas.

I had my g1 as a =today() and not as a value.

I'll probably be posting here again Im sure. you guys are awesome, great stuff.


Byron