Hi,
Since a few days my excel workbook is behaving kinda strange...
It's supposed to auto save when closed. Lately, it doesn't only save in the original location on the server, but also in other places, even local.
Whenever a user opened a folder in explorer and then afterwords opens and closes the workbook I'm talking about, a copy is saved to the folder that was opened earlier and is still active.
What makes it even more strange is that this doesn't always happen, and that the changes made to the workbook are only changed in the Original workbook and not in the copy...
The code I use to auto save is this one:
Code
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
With Worksheets("Algemeen")
If .FilterMode Then
Application.ScreenUpdating = False
.ShowAllData
.EnableAutoFilter = True
Application.ScreenUpdating = True
End If
End With
ThisWorkbook.Save
Application.DisplayAlerts = True
End Sub
Display More
Anyone an idea what might be causing this?
Thanks in advance!
Tommy