I had written a macro for resizing the QlikView app as per the user size window .
"Sub Zoom set vAutozoomSwitch = ActiveDocument.Variables("vZoom").GetContent If vAutozoomSwitch.String = "0" Then ActiveDocument.GetApplication.WaitForIdle ActiveDocument.ActiveSheet.FitZoomToWindow Else ActiveDocument.GetApplication.WaitForIdle Set prop = ActiveDocument.ActiveSheet.GetProperties prop.ZoomFactor = 1.0 ActiveDocument.ActiveSheet.SetProperties prop End If End Sub "
Then I used text box which helps to resize the window to standard size and its vice versa with actions.
This is working fine on a single sheet .
What I want is , by clicking the text box on one sheet it should get applied to all the sheets .
I tried with document triggers but it doesn't helped me.
I am trying to create an Apply2All() for sheet user permissions. Do you know if that is possible? There is an "Apply to all sheets" check box in Sheet Properties>Security, but I don't know what the variable is called or how to call it.