Share via

Microsoft Visual Basic Unexpected Error 485

Anonymous
2019-04-24T08:18:18+00:00

I have Office for Mac 2016 plan for Enterprise (Macbook Air). I'm trying to open an excel file that has macros but got the error "Microsoft Visual Basic - Unexpected Error (485)". 

I have the most updates Mac OS for Excel the version for Excel is 16.16.8 (190312)

You can also find the screen shot of the same.

Regards,

Suyog

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-04-24T09:50:19+00:00

    Hi SuyogBhandari,

    Thank you for your message.

    It is usually happening when your macros code refers to something that does not exist or no longer exists. Since you are running it on MAC the latest Version of office 2016 0n Mac is 16.16.9 (19041201), please update after re-open Excel file. Release notes for Office 2016 for Mac

    This article explains error 485

    https://msdn.microsoft.com/en-us/library/aa445468.aspx

    Check the following thread to see if it could be help for your case: 

    https://answers.microsoft.com/en-us/msoffice/forum/all/excel-error-485-on-mac/a6a1223e-45f3-4bdb-a7da-58960f3a396f

    https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-visual-basic-unexpected-error-485/5363ae7e-1b1b-42db-b8e0-dc1a8959ce5e

    To better understand the situation, I'd like to confirm the following things:

    1. Is the issue only related to this specific file which has macros or all worksheets which have macros? If you create a new worksheet with some simple macros, will the worksheet run into the same error?

    2.  Does the worksheet work well before? Do you encounter this issue after some Mac OS or Office updates?

    1. Click Excel/Apple icon on the top bar>About Excel/About This Mac>let us know current versions of your Mac OS and Excel for Mac.
    2. could you share with us the problematic worksheet via private message? We want to test it from our side. See if the issue is related to your specific Office suite or macros in that file

    If you still need any help, please feel free to let us know and thanks for your cooperation in advance.

    Regards,

    Waqas Muhammad

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2019-04-25T15:23:37+00:00

    Waqas started his reply off correctly by pointing you to the explanation of what causes error 485. Then he went crazy with his "private message" nonsense.

    You'd be much better off checking out Ron De Bruin's page here:

    https://www.rondebruin.nl/mac/mac024.htm

    0 comments
  4. Anonymous
    2019-04-26T09:32:21+00:00

    Hi SuyogBhandari,

    Please feel free to share any update with us, if you need further assistance.

    Regards,

    Waqas Muhammad

    0 comments