Microsoft Visual Basic Unexpected Error 485

Anonymous
2018-06-12T01:19:53+00:00

I have Office 365 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)". My colleague who is using the same plan can open the same file just fine from his Macbook Pro. Can you advise what to do?

Microsoft 365 and Office | Excel | For business | 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 No comments
{count} votes

8 answers

Sort by: Most helpful
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-06-16T16:46:09+00:00

    Thanks for follow-in up, Cliff. Did you also get the same error when you tried to reproduce this issue?

    0 comments No comments
  2. Anonymous
    2018-06-18T15:18:37+00:00

    Hi Jim,

    Thanks for your reply here.

    When I open a file with macro codes, I can open it fine.

    Thanks,

    Cliff

    0 comments No comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-06-20T16:30:04+00:00

    Opening any old file having a macro is not the same as opening THE file that is in question here.  Are you saying you are able to open the file provided by Nikita in version Excel version 16.14.1 or are you opening some other file?

    Exactly what line of code is failing?

    0 comments No comments