WksPageSetup Object
The WksPageSetup object contains all the parameters in the worksheet window Page Setup dialog.
Properties
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