topic Re: View Zoom in QlikView

View Zoom

robert99 — Sun, 19 Oct 2014 10:04:43 GMT

I want sheet zoom to work in smaller steps (not 25/50/75/125/150 etc)

Say 80 85 90 100 105 110 115 and 120

Is there any way this can be done

I have searched the forum but the options did not work

Like this one

sub ResetZoom15

set mySheet = ActiveDocument.ActiveSheet

set sp = mySheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor*1.5

mySheet.SetProperties sp

end sub

Although I'm unsure how to run the macro

Thanks

robert99 — Sun, 19 Oct 2014 11:05:13 GMT

Ok I've finally got this to work

I set up an action button and pasted the above script in a macro as follows

Action / add / external / run macro and then pasted into the edit module

And then clicked test.

sub ResetZoomInc

set mySheet = ActiveDocument.ActiveSheet

set sp = mySheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor*1.025

mySheet.SetProperties sp

end sub

sub ResetZoomDec

set mySheet = ActiveDocument.ActiveSheet

set sp = mySheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor*0.975

mySheet.SetProperties sp

end sub

jduenyas — Wed, 29 Oct 2014 20:19:45 GMT

Check out a solution I have posted recently Zoom Using Slider

Best regards

robert99 — Wed, 29 Oct 2014 20:40:15 GMT

Thanks

I will look at it when I return to work tomorrow