Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

macro security

Is there a way to force the system to allow macros in Access Point?  I don't want the users to have the option to allow macros or not (they always choose wrong).  If we do CTRL + SHIFT + M, it will allow them, but only temporarily.

Thanks!

2 Replies
Anonymous
Not applicable
Author

Hi,

Yes, but it's a little bit tricky.

1. All the user registry entries have now been moved to Settings.ini under:

C:\Users\USERNAME\AppData\Roaming\QlikTech\QlikView

(Note: This is for Windows Vista/7/etc.)

2. When you select the "Allow any Macro (only for trusted documents)" setting in the Module Security for Document dialog box, the user will write an entry into their Settings.ini file for future reference when accessing the same document again that looks like this:

[Module Checksums System]

A9482042-C9C84715-6AC72FD3-CC60CE86-7C39299B=

The Module Checksums System lists all the checksums for the applications where you have picked "Allow any Macro...".

3. The checksum is unique for each application, so after you've set this for one user, you can copy the checksum and paste it in the different users' Settings.ini files and QlikView will open up the application allowing macros without prompting the users.

Not applicable
Author

Hi,

will this always opens the file with "Allow System Access" even if  batch file of qvw fails ?

Thanks in advance.