Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To discard any changes to the workbook

Private Sub Workbook_BeforeClose(Cancel As Boolean)            ThisWorkbook.Saved = True      End Sub