How to remove the Change Module Security error meaasge

[sathishkumar_go]

Hi All,

In my dashboard, I am exporting a pivot chart to excel and PPT through macro.

When I am clicking a button, Initially I am getting the below error

after when I press ctrl+shift+M, I have changed to "Give System Access to Module Script"

But I have to every time. Is it any way to get rid of this permanently?

-Sathish

[sathishkumar_go]

Addition to that,

I have already done

Allow macro execution on server and the "Allow unsafe macro execution on server"

-Sathish

[sathishkumar_go]

Got a solution!

I am referring this url Change Macro security to allow System Access

Thanks Michael

-Sathish