topic Re: How to change macro security settings to allow system access in QlikView

How to change macro security settings to allow system access

Thu, 07 Aug 2014 14:11:49 GMT

Hello everyone,

I have created a macro that exports some pictures (graphs) from qlikview to a powerpoint document. In order it works, I need to select "allow system access" in the module window (in QV desktop). The problem is that each time I close the document (even if I have saved it), this setting goes back to the defaut option which is "Safe mode" (not sure about the translation but you probably get it ).

Is there a way to make "Allow system access" to be the defaut option ?

Thank you for your help.

Laura

Re: How to change macro security settings to allow system access

gandalfgray — Thu, 07 Aug 2014 14:27:32 GMT

In the Module Editor make sure the settings are like in this picture:

Then in Settings -> Document Properties set "Macro override security" as below:

And save your application

/gg

Re: How to change macro security settings to allow system access

Thu, 07 Aug 2014 14:43:43 GMT

Thank you !

Have a good day

Re: How to change macro security settings to allow system access

gandalfgray — Fri, 08 Aug 2014 05:53:29 GMT

You're welcome!

Re: How to change macro security settings to allow system access

kkkumar82 — Fri, 29 May 2015 14:34:54 GMT

Hi Gray,

When we are using macros in mashups or integration , which access we have to use , if it is safe mode or system access

or should we not use macros at all , if we use macros.

Re: How to change macro security settings to allow system access

warfollowmy_ver — Fri, 30 Dec 2016 05:14:24 GMT

It is not work in 12.0 desktop! Why? Macro security settings default - allow system access

Also, I noticed that there is a new rec in clients .ini entry in the

[Module checksum Safe]

If you copy it to another client, the window disappears.