View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
biker biker is offline
external usenet poster
 
Posts: 4
Default 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,