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