2 Replies Latest reply: May 28, 2012 8:45 AM by Sonika Jain RSS

set size of sheet using macro

Sonika Jain

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.

  • set size of sheet using macro
    Erich Shino

    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,