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

[#1]

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

[#2]

Hi Preena,

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

Regards,

Amit

[#3]

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

[prieper]

Hi,

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

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

HTH

[#5]

Hi

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

Thanks

Preena

[Anonymous]

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.

[#7]

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

[Anonymous]

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

[#9]

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.

[#10]

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