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: 
sonikajain
Partner - Contributor
Partner - Contributor

set size of sheet using macro

hi all,

Can we define the size (vertical) of a sheet...???? I want to specify the size of the sheet on click of a button.

Please advise. Am trying to do it using macro.

2 Replies
erichshiino
Partner - Master
Partner - Master

Hi, I don't believe it is possible (maybe it is with some advanced macro codes that would control the OS and adjust window size... )

You can use simple macros to adjust the zoom level of your sheet

sub setZoom

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = 0.9

mysheet.SetProperties sp

End sub

You can adjust the zoom in sp.zoomfactor

Hope this helps,

Erich

sonikajain
Partner - Contributor
Partner - Contributor
Author

hi..the zoom thing resizes the sheet objects too ....I need to keep the sheet size fixed.:(