Event handler for calling a macro (within the sub) whenever the workbook is saved
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'Your Code Here End Sub