Consulting

Results 1 to 2 of 2

Thread: Workbook.BeforeSave Event on Mac Office

  1. #1
    VBAX Regular
    Joined
    Jul 2010
    Posts
    29
    Location

    Workbook.BeforeSave Event on Mac Office

    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

  2. #2
    VBAX Regular
    Joined
    Jul 2010
    Posts
    29
    Location
    Well that was annoying... the default Save button in Mac QAT doesn't fire this event. Changing it to the Save As button works a charm!

    Question though... is there a SaveUI instead of SaveAsUI I need to use?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •