topic Re: Macros(avoid Ctrl+Shift+M) in QlikView

Macros(avoid Ctrl+Shift+M)

sagarkharpude — Tue, 08 Nov 2016 06:36:46 GMT

Hi,

I am using macros in one application. When we open it on the access point we have to press the Ctrl+Shift+M and we have to select “Give System Access to Module Script”. I want to make it more user friendly.

Can we write some code in macros so that there would be no need to press Ctrl+Shift+M on access point.

Thanks

Sagar

Re: Macros(avoid Ctrl+Shift+M)

eromiyasimon — Tue, 08 Nov 2016 06:46:40 GMT

you can assign a button to activate the macro

create a button

go to properties

go to action tab

go external division

select the option run macro

Re: Macros(avoid Ctrl+Shift+M)

marcus_sommer — Tue, 08 Nov 2016 07:56:20 GMT

The execution of macros must be allowed on the user-level (the logic is similar to ms office macros) and normally you will get a fourth option within the forced dialog of CTRL+Shift+M to remember your choosen setting which will be saved within the settings.ini from the user: C:\Users\YOURUSER\AppData\Roaming\QlikTech\QlikView\settings.ini (the settings.ini itself could be manipulate per editor).

If you don't see this option or it's greyed out then some settings within the modul security, document properties or the qmc settings are wrong (I don't know which one are essential for this - you will need some attempts or search further within the community).

- Marcus

Re: Macros(avoid Ctrl+Shift+M)

sagarkharpude — Tue, 08 Nov 2016 08:39:00 GMT

Thanks Marcus