4 Replies Latest reply: May 7, 2012 7:25 AM by Subin Thomas RSS

    How to get rid of Control +Shift+M functionality permanently?

    Subin Thomas

      Hi,

       

      I have a report which is having a functionaltiy for the users to reload the report using Macro & EDX. But the issue here is we need to explicity select the option as in the below screenshot.

      Can we make any changes in the settings which will disable and save me the time to not do it manually everytime?

      nogap.JPG

      Appreciate your answers in advance.

       

      Regards,

      Subin

        • How to get rid of Control +Shift+M functionality permanently?
          m w

          '// ************************************************** 

          '// Script for adding some registry keys to the current user profile/registry settings 
          '// for enabling the macro security/module security for the SERVER defined below 
          '// ~ 

          '// CONFIGURATION 

          '// Just configure the script by defining your server below 

          '// ~ 

          '// The article explaining this script can be found at 

          '// http://www.qlikblog.at/523/ 

          '// ************************************************** 

          CONST cSERVER_NAME = "YOUR_SERVER_NAME"

          Dim WshShell 'as Object 

          ' Delete any registry entries where the user blocked script for the server
          on error resume next
          WSHShell.RegDelete "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script Blocked\" & cSERVER_NAME
          WSHShell.RegDelete "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script Blocked\"
            

          Set WshShell = WScript.CreateObject("WScript.Shell") 

          WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\", 1, "REG_SZ" 

          WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\", 1, "REG_SZ" 

          WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\ " & cSERVER_NAME, "", "REG_SZ"