IRM • Microsoft 365 Family

German Varona 1 Reputation point
2021-06-28T19:55:04.967+00:00

Good morning, I am needing to give company users the ability to run macros even though I set a file with IRM permissions to "Extremely Confidential / All Employees", but I am not able to. I notice that for that I must give them Total Control permissions, but this makes no sense, because by giving them that permission they have the ability to get IRM permissions.
Please, could you tell me how to restrict access to the use only of employees to give them permission to run the macros and in turn cannot have permissions to modify the IRM configuration? Greetings,

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,641 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 21,856 Reputation points Microsoft Vendor
    2021-06-29T06:41:25.927+00:00

    Hi @German Varona ,
    I suggest you refer to this similar problem, and as Leo_Gao suggestion, you can add the code to help you run Macro:

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/59ef2de7-438f-447c-9cce-79ec9484fa63/applying-irm-protection-to-macroenabled-workbook?forum=exceldev

    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.