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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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