Se7enSquared
10/18/2019 - 11:37 PM

Run a macro on save

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