topic Re: How to reset Macro authorizations in QlikView

How to reset Macro authorizations

partenope — Wed, 20 May 2009 23:19:51 GMT

Hi all,

when a new QV document with Macro inside is opened by a user, a pop-up asks him witch level of security he wants to set. Normally all users choose a wrong level and set a flag "save this value".

when it happens, the user can never change this parameter!

there is "ctrl+shift+M" key combination to reset temporarily the security, but at each new open the security value returns like first selection.

there is a way to re-set security value and ask again to the user the macro security level?

thanx, Dario

How to reset Macro authorizations

Anonymous — Wed, 20 May 2009 23:25:54 GMT

Dario,
User's choice goes to the registry, see under ...\QlikTech\QlikView\ for checksums - there could be Block, Safe, and System, as I can recall. Delete all them completely, and after this user will have to re-enter the choice again.

How to reset Macro authorizations

Thu, 21 May 2009 00:02:15 GMT

Dario,

At plugin install time we runa little vbs script which sets the registry to always trust the server - change 'myserverid' as appropriate:

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\myserverid", "", "REG_SZ"

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

Regards,

Gordon

How to reset Macro authorizations

partenope — Thu, 21 May 2009 15:23:38 GMT

I'll try,

thanx to all!

How to reset Macro authorizations

m_woolf — Mon, 09 Nov 2009 21:21:26 GMT

What do you mean by "Server ID?"

Re: How to reset Macro authorizations

erichshiino — Wed, 10 Oct 2012 12:15:25 GMT

Hi,

Is it still the only way to reset those settings?

Regards,

Erich

Re: How to reset Macro authorizations

Anonymous — Wed, 10 Oct 2012 14:49:32 GMT

Erich,

It is different in Windows 7. See file

C:\Users\USERNAME%\AppData\Roaming\QlikTech\QlikView\Settings.ini

The file is structured much the same as the registry settings.

Regards,

Michael

PS: For some reason, I don't receive notifications about posts in the older threads. It is safer to start new.

Re: How to reset Macro authorizations

erichshiino — Wed, 10 Oct 2012 15:59:20 GMT

I guess I got lucky!

Thank you a lot!

Erich