Microsoft Office Tutorials and References
In Depth Information
Chapter 18. The Worksheet Object
Chapter 18. The Worksheet Object
A Worksheet object represents an Excel worksheet. Figure 18-1 shows that portion of the Excel
object model that relates directly to worksheets.
Figure 18-1. The Worksheet object
18.1 Properties and Methods of the Worksheet Object
Table 18-1 shows the members of the Worksheet object.
Table 18-1. Members of the Workshee t Object
_CheckSpelling<v9>
DropDowns
Previous
_CodeName
EnableAutoFilter
PrintOut
_DisplayRightToLeft<v9>
EnableCalculation
PrintPreview
_Evaluate
EnableOutlining
Protect
_PasteSpecial<v10>
EnablePivotTable
ProtectContents
_PrintOut<v9>
EnableSelection
ProtectDrawingObjects
_Protect<v10>
Evaluate
Protection<v10>
_SaveAs<v10>
FilterMode
ProtectionMode
Activate
GroupBoxes
ProtectScenarios
Application
GroupObjects
QueryTables
Arcs
HPageBreaks
Range
AutoFilter
Hyperlinks
Rectangles
AutoFilterMode
Index
ResetAllPageBreaks
Buttons
Labels
Rows
Calculate
Lines
SaveAs
Cells
ListBoxes
Scenarios
 
 
 
 
Search JabSto ::




Custom Search