Share via

how to enable macro of excel worksheet received via email

Ricky Chung 0 Reputation points
2024-05-24T04:35:27.37+00:00

How to make an excel file a trusted document so that I can enable the marcos?

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2024-05-24T08:34:03.58+00:00

    Hi,

    Try this method:

    Open Excel- go to File- Options- Trust Center- Trust Center settings...:

    1. Macro settings- select the option Enable VBA macros:
      User's image
    2. Protected View- uncheck the option Enable Protected View for Outlook attachments:
      User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.