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 SHIINO

    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