VBA to turn off AutoSave but not Save as it is actioned

[micah1880]

I am currently using this VBA code to turn off AutoSave:

    If Val(Application.Version) > 15 Then
        If ActiveWorkbook.AutoSaveOn Then ActiveWorkbook.AutoSaveOn = False
    End If

Every time this code is run the file will Save before I can carry on.

This is a large file so this Save is time consuming, and I would like to by-pass it.

Please can you advise if there is some VBA code I can add that will prevent the Save after AutoSave is turned off?

Thanks

 

[Micron]

It seems that ThisWorkbook.Saved = True won't prevent a save when turning off autosave. All I can think of is that you create a public variable and if autosave is on, set its value to False (or whatever you want). Then use the workbook beforesave event to check the variable and Cancel save in that event. Someone else might have a better idea.