Does anyone know if it is possible to cancel a workbook close process via vba code? I'm using the following code and if two ranges are not equal a message appears indicating so but I need to cancel the close process itself.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Range("R_one") <> Range("R_two") Then
MsgBox "Two Ranges do not equal"
' Insert Code Here to cancel workbook close feature...