MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Closing a workbokk discarding changes

Posted by Henry Collet on February 11, 2002 10:21 AM

When I close a workbook how can i get it to stop asking me if i want to save the changes?

Posted by DK on February 11, 2002 10:23 AM

If you are talking about a VBA method then put this in your workbook code module.

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