Microsoft Office Tutorials and References
In Depth Information
Figure G-1. The Error Checking tab
RowItems() As PivotItemList
Item(Index As Variant)
As PivotItem
Count() As Long
PivotItemList
New to Excel XP is the PivotCell object, which represents a cell in a pivot table. For more on this
object (and the PivotItemList object), please see Chapter 20 .
Protection Object
Path: Application -- Range -- Worksheet - Protection
Object
Properties
AllowDeletingColumns() As Boolean
AllowDeletingRows() As Boolean
AllowEditRanges() As AllowEditRanges
AllowFiltering() As Boolean
AllowFormattingCells() As Boolean
AllowFormattingColumns() As Boolean
AllowFormattingRows() As Boolean
AllowInsertingColumns() As Boolean
AllowInsertingHyperlinks() As Boolean
AllowInsertingRows() As Boolean
AllowSorting() As Boolean
AllowUsingPivotTables() As Boolean
Protection
When you protect a worksheet, Excel permits you to specify that certain operations are still
permitted on unlocked cells. At the user level, this is done through the Protection dialog box. At
the programming level, it is done through the properties of the Protection object.
RTD Object
Path: Application - RTD
Object
Methods
Properties
RefreshData()
RestartServers()
ThrottleInterval() As Long
RTD
The RTD object represents a real-time data object, a subject that we do not cover in this topic.
Search JabSto ::




Custom Search