Macro Security Dialog

[amayuresh]

Hi,

I have application with "Export to Excel" Macro. When I am sharing this application to another user, below dialog box showing.

I did setting at module level as:

Requested Module Security = System Access

Current Local Security = Allow System Access

How can I hide this dialog box for all users ?

Is there any setting at document level ?

[marcus_sommer · Accepted solution]

You could hide these dialog only if you adjust the settings.ini from each user in an appropriate way. But if the user press the third radio-button and the option below them "Always ..." those dialog appeared only once - whereby it's not quite clear to me why the last option is greyed out, maybe some security settings related to macros must be enabled within the qmc or document properties.

- Marcus

[amayuresh]

Is there any other way to hide this ?

[amayuresh]

This file is not on Server. We are using it on desktop. Because of this may be that last option is disable.

[marcus_sommer]

This is not a server setting else it's a user-setting and this settings.ini reside within the user-profile of each user - it's quite the same like the execute-macros settings by MS office. This meant you couldn't change it simply - but your IT would be capable to change this with adding/adjusting a start-script during the logon-process on windows. Otherwise you have to deal with these dialog.

- Marcus

[tamilarasu]

I guess, If the user press the "Allow Safe Macros" option, they will not see this prompt again for the specific document. If the code is modified in the document, users will be prompted again.

Below link might be helpful.

Getting rid of the "Module Security for Documen... | Qlik Community

[coyjohn1]

I recently had the same error and set my document security to:

Requested Module Security

System Access

And

Current Local Security

Allow System Access

Additionally I also Checked on Change Module Security Dialogue box

Give System Access to Module Script

This has not resolved my issue. Are there any other settings I need to look at?