If Right(ThisWorkbook.Path, 19) “Client_Applications” Then
Dim FName As String
Do Until Right(FName, 19) = “Client_Applications”
FName = BrowseFolder(Caption:=”You Must Select the Clients_Application Folder”)
Loop
ChDir (FName)
End If

Hey – when it’s naming the file for the first time – no problem – I get a save with a unique file name.

HOWEVER – when I go to click my save button again AFTER I made changes to the spreadsheet – it goes through the Save As routine – asks me if I want to overwrite (which I want in this case) I see the progress bar at the bottom left do its thing for a save. But when I close out of the spreadsheet and reopen the file that was just saved – the fields I changed are back to what they were BEFORE I pressed my save routine!!!!

I saved an excel document in SharePoint as a template for a new document. I wanted to control everything so the user can’t change the FileName nor the path, so I don’t want any prompt at all. The methods Application.DisplayAlerts = False and ThisWorkbook.Saved still prompted the user.

The trick that did it for me is the “cancel=true”, which I used after I saved the file.
Problem solved.