SaveAs Macro still asks me on exit to save file

[JohnZ1156]

I have an Excel Workbook with many sheets. After I enter my new data, I created a button and assigned a macro to save the file to multiple locations. Two "backup" locations and my primary location.
Even though I run the macro and it saves the file, when I go to close the workbook or exit excel, it asks me if I want to save the file again?

Here is my macro.

Sub SaveAllOver()

    Application.DisplayAlerts = False
    ThisWorkbook.SaveAs "E:\Finance\Finances.xlsm", 52
    ThisWorkbook.SaveAs "Z:\Finance\Finances.xlsm", 52

    'ThisWorkbook.Save
    MsgBox ("The " & Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 5) & " Workbook was saved!")
    ThisWorkbook.SaveAs "C:\Users\John\Documents\Finance\Finances.xlsm", 52
    Application.DisplayAlerts = True
        
End Sub

 

[cmowla]

If he had originally saved it as xlsb then he would need to use the 52 as it is a change in fileformat

That doesn't mean it originally started as xlsm, he had already saved it using 52 in the original code. What the file started as you don't know.

Anyway this post is diverting away from the main question a bit. @JohnZ1156 please don't miss post number 7 by GWteB.

If the , 52 is needed for his case, just one question: How is he saving the file at all with this code? I get the following error

when I tried to save a copy of a .xlsb file as .xlsm with the .xlsm in the filePathString and with the , 52 omitted . . . and with Application.DisplayAlerts OFF.)

 

[Fluff]

Try doing it with an xls file.
Now if you want to discuss this further please start a thread of your, rather than hijacking this thread.

@JohnZ1156 do you have any formulae that include volatile functions?