Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Addition to that,
I have already done
Allow macro execution on server and the "Allow unsafe macro execution on server"
Got a solution!
I am referring this url Change Macro security to allow System Access