Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Get Rid of Module Security Dialog Box when Exporting to Excel

How to get rid of  "Change Module Security" Dialog Box , When a User tries to Export chart to Excel using a Button(Runs a Macro) in IE plugin, they need to check the option "Give System Access to Module Script" and some users dont get the dialog box at all and we asked them to click "Ctrl+Shift+M" and check the Give System access option, But it is annoying to Check this option everytime they login.

I tried the options mentioned in QLikview Forums

Desktop

Settings -> DocumentProperties ->Security -> Macro Overide Security is Checked

Settings -> UserPreferences -> Security ->Module, Launch & Confirm Launch from Macro are Checked

Qlikview Managemnet Console Server

Security ->Allow Unsafe Macro Execution on Server & Allow Macro Execution on Server are Checked

Is there a possible way to Export to excel without checking the Dialog box or CtlShtM

8 Replies
Not applicable
Author

Hi Shalini,

Just go to the edit module screen and change the Requested module security to "System Access" and Current Local Security to "Allow System Access".

module security.JPG

Thanks & Best Regards,

Kuldeep Tak

Not applicable
Author

Hi Kuldeep,

I have already made that security setting and it works on desktop version. I tried all the settings suggested in Qlik community.

~Shalini.

Bill_Britt
Former Employee
Former Employee

Don't think you will be able to with using a Macro. Not sure what you are trying to do with the export, but you can always put the icon on the item you want to export.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

Bill,

We are not just Exporting one table to excel but multiple tables from different tabs which should be exported to one excel with respective sheets, and I don’t think this can be achieved without a Macro.

Bill_Britt
Former Employee
Former Employee

That is what I was figuring you were trying to do. Unfortunate you will have to have the end user enable the security on their machines.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
fosuzuki
Partner - Specialist III
Partner - Specialist III

As far as I know, the 'Give System Access to Module Script' IE Plugin option is stored in a Settings.ini file located at C:\Users\username\AppData\Roaming\QlikTech\QlikView (Win7 folder) in the client machine. When you open the file, there should have a piece of code like:

[Settings for QlikView Servers]

Module Script System\servername1=

Module Script System\servername2=

Module Script System\servername3=

I once had this problem when the clients were using Citrix Server (a kind of Terminal Server application, not from Microsoft), but the user profile was deleted when the used logged off, so the Settings.ini never persisted. I had to modify the logon batch so that a Settings.ini file with the above code was copied to the user's profile when the user logged in.

Not applicable
Author

Fernando,

Unfortunately I cannot do that because the User base for this application is very large and modifying settings in their machines has to go through many approvals and not feasible. I was wondering if there is nothing we can do on the server to eliminate the dialog box can we atleast make sure that “Change Module Security” dialog box appears for all the users, as of now it is inconsistent some users can see the dialog box when they click the Button and for some nothing happens and they have to do “CtrlShftM”, Can we make sure the Dialog box appears for all the users and we can train them to Select “Always give system access option”

Bill_Britt
Former Employee
Former Employee

There is nothing you can do on the server side. This is all Client side actions.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.