Excel for Mac - Runtime Error 91: Object variable or With block variable not set

Anonymous
2022-07-31T12:28:56+00:00

Split from this thread.

Hi please help, I have a Mac OS so what steps do Mac users of Office have to take to unblock?

Please see the image for the error I am getting.

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

1 answer

Sort by: Most helpful
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-07-31T16:38:21+00:00

    Hi

    The error message does not say "Microsoft has blocked Macros from running because the source is untrusted." In fact, the error message that your screen shot shows proves that macros are running.

    The error message is due to a coding error in a macro.

    Did you write the macro or did someone else? The macro needs to be fixed.

    3 people found this answer helpful.
    0 comments No comments