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?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 25,551 Reputation points Microsoft Vendor
    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.