VBA code to remind the Excel sheet user to run the Macro

SamFares

The following will work if the workbook only prompts to be saved when it is closed if the user has changed something.

Press Alt+F11 to activate the Visual Basic Editor.

Double-click ThisWorkbook under Microsoft Excel Objects.

Copy the following code into the ThisWorkbook module:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    If Not Me.Saved Then
        Select Case MsgBox("Do you want to run the design macro now?", vbQuestion + vbYesNoCancel)
            Case vbYes
                Call DesignMacro
            Case vbNo
                ' Just continue
            Case vbCancel
                Cancel = True
        End Select
    End If
End Sub

where DesignMacro is the name of the macro that should be run.