locked
Mac Excel 2016 Unexpected error (485) RRS feed

  • Question

  • Mac 2016, x64, 365
    After Debug/Compile a couple of empty messages appear except for title "Microsoft Visual Basic" and the OK button, followed by a second message "Unexpected error (485)". If I try and run a macro the same messages appear.

    The project compiles fine in Windows all 32/64bit versions 2007 to 2016 and in Mac 2011. There is plenty of use of #If Mac / Win64 / VBA7 / Win32 to handle respective versions. All API declarations and calls to APIs are not exposed to Mac.

    When the error message appear no code is highlighted or procedure jumped to.

    Does anyone know of any scenarios could be related to this compile problem and unhelpful message?

    Friday, March 30, 2018 2:44 PM

All replies

  • I experienced this error message today and traced it to a UserForm that had a control with a custom Pointer image set using the Windows-specific .cur image format. I removed the custom pointer and the error disappeared. Windows used .cur and .ico while Mac uses .icns but for now, there is no UI to access userforms in the Mac 2016 VBE so turning it off appears to be the only solution.

    Presentation specialist and VBA macro/add-in developer for PowerPoint http://youpresent.biz

    Thursday, April 19, 2018 9:31 PM
  • Thanks Jamie, yes exactly that. I found it a little while after posting and should have followed up, but pleased to see someone else report same.

    I removed the custom cursor completely, but could you clarify when you say "turning it off" do you mean same or simply changing the control's MousePointer property from fmMousePointerCustom to fmMousePointerDefault. 

    As I mentioned no problems in Mac 2011 providing a form with a custom cursor in any control is not loaded. OTH Mac 2011 crashes if a form is loaded that includes certain types of gif images originally added in Windows, yet no problem in Mac 2016 even to load and show such images.

    Friday, April 20, 2018 8:49 AM