Save Copy Problem
When an excel file (read only) is loaded and then the user goes to save it.
It then asks the user to save a copy. How do I prevent this from popping up?
I thought of
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
ActiveWorkbook.Close (SaveChanges = False)
End Sub
But I'm not sure if it always works and if its good to remove display alerts
Is this the correct way to do this?
Thanks,
|