Executing macro only once on open

[CStumpo]

hello
I'm new to Excel Forum and a novas with Excel VB.
I have a macro named AddSub which subtotals the rows of my file by company name. That macro works. What I want to do is have the macro run and the file save when the user opens the file for the first time - but only the first time. The macro does not need to execute each time the file is opened which is happening now. At the workbook level I have the open command and the macro below listed. AddSub is my subtotal macro which I want to run, then the file save. The next time the file is opened - nothing should happen. Thanks.

Private Sub Workbook_Open()
AddSub
ActiveWorkbook.Save
End Sub

[davesexcel]

If the code is run the first time, would you be able to add today's date into a cell, then the next time the code is run, only run if that cell does not equal today's date.

[CStumpo]

Hello,
I don't want the code run again. Once the subtotal macro runs - it need not run again. It's just a subtotal.

[davesexcel]

Yes, just run the code if today's date is not in the cell.......

[CStumpo]

if the macro is run today and 5/22/2018 is in the cell, then the file opened tomorrow (5/23) will the macro run? Our Finance department will open the file and use it multiple times.

[davesexcel]

If you want it only to run once, when the workbook is opened, it will check if the cell has today date in it, if not, then it will run the code, and place the date in the cell, so that next time the wb is opened, if first checks the date of the cell to see if it has to run the code or not.