set size of sheet using macro

[sonikajain]

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.

[erichshiino]

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]

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