If you want Excel to stop prompting you to save changes you didn't make
Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Saved = True End Sub