Pages

Friday, March 23, 2012

The BeforeClose event for a workbook

The BeforeClose event for a workbook

Private Sub Workbook_BeforeClose(Cancel As Boolean)

   ThisWorkbook.Save

    MsgBox "Bye " & Application.UserName

End Sub

No comments:

Post a Comment