Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to Execute a Macro with button

Hi

i have a macro script and i want to run this macro with a button , how should i do it ?

i add button under Action i select "Run macro" , now what ? where should i copy the macro script ?

what is "macro name " .

thank you

9 Replies
tresesco
MVP
MVP

Open Application->Ctrl+M, you get to place your code. Your code should be something like : Sub test() --- End Sub.

Now in the macro name, you have to type test.

MK_QSL
MVP
MVP

Go to Action tab of Button Properties

Add

External

Run Macro

OK

Macro Name  : Type Name of Macro You want to RUN

Not applicable
Author

Hi

thank you

but where should i copy the script of the macro ? where i create my macro ?

in the editor ?

tresesco
MVP
MVP

macro.png

MK_QSL
MVP
MVP

Press CTRL + M...

Not applicable
Author

Sorry but I don't know the "Module  Password"

tresesco
MVP
MVP

It would have been great, if I knew.

Not applicable
Author

fkeuroglian
Partner - Master
Partner - Master

Tools / Module edit

then you have to write vbscript or java script code to create macro

good luck