topic set size of sheet using macro in QlikView https://community.qlik.com/t5/QlikView/set-size-of-sheet-using-macro/m-p/364204#M135508 <HTML><HEAD></HEAD><BODY><P> hi..the zoom thing resizes the sheet objects too ....I need to keep the sheet size fixed.:(</P></BODY></HTML> Mon, 28 May 2012 12:45:57 GMT sonikajain 2012-05-28T12:45:57Z set size of sheet using macro https://community.qlik.com/t5/QlikView/set-size-of-sheet-using-macro/m-p/364202#M135506 <HTML><HEAD></HEAD><BODY><P> hi all, </P><P></P><P>Can we define the size (vertical) of a sheet...???? I want to specify the size of the sheet on click of a button. </P><P></P><P>Please advise. Am trying to do it using macro.</P></BODY></HTML> Tue, 22 May 2012 20:04:37 GMT https://community.qlik.com/t5/QlikView/set-size-of-sheet-using-macro/m-p/364202#M135506 sonikajain 2012-05-22T20:04:37Z set size of sheet using macro https://community.qlik.com/t5/QlikView/set-size-of-sheet-using-macro/m-p/364203#M135507 <HTML><HEAD></HEAD><BODY><P>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... ) </P><P></P><P></P><P>You can use simple macros to adjust the zoom level of your sheet </P><P></P><P>sub setZoom</P><P>set mysheet=ActiveDocument.ActiveSheet</P><P>set sp=mysheet.GetProperties</P><P>sp.ZoomFactor = 0.9</P><P>mysheet.SetProperties sp</P><P>End sub</P><P></P><P>You can adjust the zoom in sp.zoomfactor</P><P></P><P>Hope this helps, </P><P></P><P>Erich</P></BODY></HTML> Thu, 24 May 2012 02:33:11 GMT https://community.qlik.com/t5/QlikView/set-size-of-sheet-using-macro/m-p/364203#M135507 erichshiino 2012-05-24T02:33:11Z set size of sheet using macro https://community.qlik.com/t5/QlikView/set-size-of-sheet-using-macro/m-p/364204#M135508 <HTML><HEAD></HEAD><BODY><P> hi..the zoom thing resizes the sheet objects too ....I need to keep the sheet size fixed.:(</P></BODY></HTML> Mon, 28 May 2012 12:45:57 GMT https://community.qlik.com/t5/QlikView/set-size-of-sheet-using-macro/m-p/364204#M135508 sonikajain 2012-05-28T12:45:57Z