Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how disable security macro check

Hi to all,

I devolop a .qvw with a macro in VB Script.

So, when I open the document the first time after a modify in the macro, an alert box appears with three options about security permissions of macros.

Is it possible to able security permissions so that macros run always without alert box appears?

Thanks in advance

stefano

4 Replies
Not applicable
Author

What I do with an install of the plugin is to set the registry on the users PC so that the Qlikview server is 'trusted'. Its a simple VBS:

Dim WshShell

Set WshShell = WScript.CreateObject("WScript.Shell")

' It does not matter if this is run more than once as it will just overwrite existing values
WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\", 1, "REG_SZ"
WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\", 1, "REG_SZ"
WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\yourserverid", "", "REG_SZ"

WScript.Echo "(: Plugin Macros are now enabled :)"

Just change 'yourserverid' as required.

Regards,

Gordon

Not applicable
Author

Thank you Gordon!

but if I have a "standalone" installation, without QlikVIew Server and Plugin... ?

Perhaps I have to modify HKCU\Software\QlikTech\QlikVIew\Settings 7\MacroLaunchConfirmation ?

Bye

Not applicable
Author

Did that resolve your issue?

Not applicable
Author

Yes, I resolved it!

You have to UNcheck the "Confirm Launch from Macro" (and, if you want, to check all others) option in Settings à User Preferences à Security

Thanks, bye!