Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
beforesave macro help
Hi,
Can someone please tell me why the following code keeps crashing my excel? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Range("G5") = "" Or Range("D7") = "" Or Range("G7") = "" _ Or Range("D9") = "" Or Range("G9") = "" Or Range("D11") = "" Then Cancel = True MsgBox "Please complete all Mandatory Fields" Exit Sub Else Application.Dialogs(xlDialogSaveAs).Show End If End Sub Thank you in advance, any help on this will be greatly appreciated Regards Arran |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
beforesave | Excel Programming | |||
BeforeSave macro | Excel Programming | |||
Run macro with BeforeSave Event | Excel Programming | |||
Trying to run macro on the BeforeSave event | Excel Programming | |||
BeforeSave Sub | Excel Programming |