ldoodle
02-05-2020, 07:22 AM
Hi,
I'm doing this in ThisWorkbook:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
Call SomeOtherSub
End Sub
On Windows Office this works fine. In Mac Office, this even does not fire when using the applications Save button. If I use the Save button in the VBA Editor window, it does work.
WTF?!!
Thanks
I'm doing this in ThisWorkbook:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
Call SomeOtherSub
End Sub
On Windows Office this works fine. In Mac Office, this even does not fire when using the applications Save button. If I use the Save button in the VBA Editor window, it does work.
WTF?!!
Thanks