Disabling the "want to save your changes?" dialogue box when closing out of Excel

[ktielens]

I have a workbook that is stored as read only on a SharePoint site. Users are unable to save the document (save as is allowed), but when closing out of the document, the dialogue box still shows saying "Want to save your changes to [file name]" with options of "save" "don't save" and "cancel".

Is there a way to disable this box from appearing? It only serves to confuse the users. Upon closing I would like the document to close without any kind of save or notification regarding saving.

Thank you in advance.

 

[Misca]

Something like

Private Sub Workbook_BeforeClose(Cancel As Boolean)

With ThisWorkbook


    If .Path = "C:\My Folder Path" And .Name = "My Workbook Name.xlsm" Then
        .Saved = True
    End If


End With


End Sub

should do. Just replace the Path & FileName with the actual path and file name and you should be covered. Remember that VBA is case sensitive: UCase() or LCase() functions can be used to turn everything upper or lower case.

 

[ktielens]

Something like

Private Sub Workbook_BeforeClose(Cancel As Boolean)

With ThisWorkbook


    If .Path = "C:\My Folder Path" And .Name = "My Workbook Name.xlsm" Then
        .Saved = True
    End If


End With


End Sub

should do. Just replace the Path & FileName with the actual path and file name and you should be covered. Remember that VBA is case sensitive: UCase() or LCase() functions can be used to turn everything upper or lower case.

Ok thanks. I will need to do some more research on that, as the document is stored on a SharePoint site.

 

[ktielens]

Something like

Private Sub Workbook_BeforeClose(Cancel As Boolean)

With ThisWorkbook


    If .Path = "C:\My Folder Path" And .Name = "My Workbook Name.xlsm" Then
        .Saved = True
    End If


End With


End Sub

should do. Just replace the Path & FileName with the actual path and file name and you should be covered. Remember that VBA is case sensitive: UCase() or LCase() functions can be used to turn everything upper or lower case.

Actually, I do not want them to be able to perform a save as, so maybe I will look into that first!