Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Zoom

This is the macro for Zooming a sheet

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = 1.5

mysheet.SetProperties sp

I want to that if i click on the button Zoom factor should keep on increasing. Say if i click for the first time it should zoom to 1.5 times and if i click second time it should zoom to 2 times. How it can be done ??

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You mean like this?

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor+0.5

mysheet.SetProperties sp

Celambarasan

View solution in original post

4 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You mean like this?

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor+0.5

mysheet.SetProperties sp

Celambarasan

Not applicable
Author

Thanks a lot

Anonymous
Not applicable
Author

Hi

    

          Using the variable you can done it

Regards

Ashok

Not applicable
Author