topic How to Remove Macro Security Alert Box coming on opening qvw? in QlikView

How to Remove Macro Security Alert Box coming on opening qvw?

Wed, 22 Apr 2009 18:34:19 GMT

Hi All

Is thier any way to remove the "Allow Any Macro" message box and set the settings internally for the 3 radio buttons that comes in the alert box while opening the report.

Alert box comes when we set the Requested MOdule security and Current loac security to : System Access.

Thanks

Preena

How to Remove Macro Security Alert Box coming on opening qvw?

Thu, 23 Apr 2009 02:32:42 GMT

Hi Preena,

Change the Requested Module to Safe Mode and Current Loac secutirty : allow create objects. This will help you.

Regards,

Amit

How to Remove Macro Security Alert Box coming on opening qvw?

Thu, 23 Apr 2009 15:47:53 GMT

Hi amit

Thanks for your reply ! but it's not working . Actually i have written a macro in which i am opening another report and this macro is giving error if i donot select

Requested Module Security : System Access

and Current Local Security :Allow System Access.

Now the problem comes while opening the reports user have to select Allow Any Macro radio button option . I want to avoid that internally through some code if possible.

Thanks

Preena

How to Remove Macro Security Alert Box coming on opening qvw?

prieper — Thu, 23 Apr 2009 16:17:02 GMT

Hi,

believe that for each document this question is only asked once?

Only when having renamed a document, users will be prompted again.

HTH

How to Remove Macro Security Alert Box coming on opening qvw?

Thu, 23 Apr 2009 16:22:21 GMT

I am sorry , i didin't get you. Macro asks for security evertime opening a report .

Thanks

Preena

How to Remove Macro Security Alert Box coming on opening qvw?

Anonymous — Thu, 23 Apr 2009 20:37:18 GMT

This is perhaps not the cleanest approach but here goes:

When a user opens a document and accepts macros to access system an entry is created in the registry under:
My Computer\HKEY_CURRENT_USER\Software\QlikTech\QlikOcx\Module Checksums System

The checksums look like this:

6A49E218-45AD7F08-71F27FEC-99FCF49C-EAA0E6A8

If you open it up once on a client you will know what the proper checksum is for that document and you'll be able to add this key to other clients to automatically allow the opening of the document with full macro rights without the user having to click the macro dialog.

How to Remove Macro Security Alert Box coming on opening qvw?

Fri, 24 Apr 2009 21:08:37 GMT

Hi jsn

Thanks for your reply ! I am able to see the checksum number .Do every client needs to copy this checksum on his machine to the same location so that macro does not asks for security ?.

Thanks

Preena

How to Remove Macro Security Alert Box coming on opening qvw?

Anonymous — Sun, 26 Apr 2009 05:45:39 GMT

That's correct Preena. Allowing macros is a user side setting so this has to be controlled for every client machine.

How to Remove Macro Security Alert Box coming on opening qvw?

Thu, 29 Apr 2010 19:24:09 GMT

Johannes,

Forgive my ignorance, but how exactly do I access this registry? Or, how would I change this for another user?

Thanks for your help.

How to Remove Macro Security Alert Box coming on opening qvw?

Thu, 29 Apr 2010 19:37:43 GMT

Johannes -- I found the setting with the help of Michael Solomovich here http://community.qlik.com/forums/p/17220/67345.aspx#67345

I had to run Regedit from my local computer -- not the production server hosting the QVWs.

Thanks - Tyler