[dba-Tech] Excel VBA -- don't save

Susan Harkins ssharkins at gmail.com
Fri Sep 3 17:40:15 CDT 2010


I'm using the procedure included below in an Excel worksheet, to keep Excel from saving any changes -- when the user clicks Close, I want Excel to close without saving changes and without asking if the user wants to save changes. This doesn't seem to work. 

Sub CloseActiveWBNoSave()
  'Close the active workbook without saving.
  ActiveWorkbook.Close False
End Sub

Any help? 

Susan H. 


More information about the dba-Tech mailing list