WksPageSetup Object

 

The WksPageSetup object contains all the parameters in the worksheet window Page Setup dialog.

 

Properties

AdjustToPercentage

Application

BottomMargin

CenterHorizontally

CenterVertically

FitToPagesAcross

FitToPagesDown

Footer

FooterMargin

Header

HeaderMargin

LeftMargin

Orientation

PaperSize

PaperSource

Parent

PrintAcrossAndThenDown

PrintBlackAndWhite

PrintGridlines

PrintRowAndColumnHeader

RightMargin

TopMargin

 

Example

The following script demonstrates how the WksPageSetup object is used in reference to the Worksheet object.

 

Sub Main

 'Declares GrapherApp as an object

  Dim GrapherApp As Object

 

 'Creates an instance of the Grapher Application

 'object and assigns it to the variable named "GrapherApp"

  Set GrapherApp = CreateObject("Grapher.Application")

 

 'Makes Grapher visible

  GrapherApp.Visible = True

 

 'Declares Wks as an object

  Dim Wks As Object

 

 'Creates a worksheet document in Grapher

 'and assigns it to the variable named "Wks"

  Set Wks = GrapherApp.Documents.Add(grfWksDoc)

 

 'Declares WksPageSetup as an object

  Dim WksPageSetup As Object

 

 'Assigns the worksheet document page setup

 'to the variable named "WksPageSetup"

  Set WksPageSetup = Wks.PageSetup

End Sub