ndendrinos
Well-known Member
- Joined
- Jan 17, 2003
- Messages
- 1,694
Hello to all,
Is it possible to incorporate in this code a message box (yes/no) that would execute the code if "yes" is chosen and not run the macros if "no" is chosen but still save the workbook ? ... Thank you
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If ActiveSheet.Name <> "Template" Then Exit Sub
Application.ScreenUpdating = False
gatti
sofka
resetform
Application.ScreenUpdating = True
End Sub
Is it possible to incorporate in this code a message box (yes/no) that would execute the code if "yes" is chosen and not run the macros if "no" is chosen but still save the workbook ? ... Thank you
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If ActiveSheet.Name <> "Template" Then Exit Sub
Application.ScreenUpdating = False
gatti
sofka
resetform
Application.ScreenUpdating = True
End Sub