macro to set document properties show sheet

Tom-Z — Sat, 16 Nov 2024 20:45:19 GMT

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 !!!

Re: macro to set document properties show sheet

Frank_Hartmann — Sun, 09 Jun 2019 11:31:20 GMT

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

topic macro to set document properties show sheet in QlikView

macro to set document properties show sheet

Re: macro to set document properties show sheet