Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Tom-Z
Contributor
Contributor

macro to set document properties show sheet

Hi,

I am new to macro programming and QlikCommunity.

I copied a macro from this forum to provide a "slideshow" effect rotating between tabs via setting the Conditional formula  to vShow =1, vShow2, etc on each tab in Show Sheet.  This works fine.

I now have a requirement to be able to "freeze " a tab. 

What I would like to do is to provide a button (Stop SlideShow ) that would execute a macro to set the Show Sheet property from Conditional to Always and another button (Resume ) to revert back to Conditional, but cannot find any reference to that property so far.

Is my solution possible ?  If so, could you provide either a reference for me to look at or the macro to set the property.

Thank you all in advance for your help !!!

 

 

 

 

 

 

 

Labels (1)
1 Reply
Frank_Hartmann
Master II
Master II

you can interrupt macro execution by pressing:
CTRL + Pause/Brk