Forum Discussion
Solved
VBA code to remind the Excel sheet user to run the Macro
Hello, I have created a macro for design in an excel sheet that has two tabs in it. What is the VBA code if a user make any input changes to remind him in the end before he exists to run the des...
You have copied the code into the code module of the CJ Design and Addl Composite Stage Loads sheets instead of into the ThisWorkbook module.
Hello Hans,
If I make changes in the Excel sheet and I "Save" the sheet before exiting then the reminder macro to run the DesignMacro message doesn't pop on the screen. It works fine if I try to exit without saving. How do you account for that condition so the message window shows up when i save or exit.
Thanks,
Sam
Asking both when the user closes the workbook and when it is saved is bound to be confusing.
See if you can live with the following:
Delete the Workbook_BeforeClose event procedure from the ThisWorkbook module.
Add the following code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
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 Sub- Thanks a lot Hans. I like it because it works for conditions.
Sam