Slicer Properties (Excel)
.png "GitHub-Mark-64px") |
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Properties
Name |
Description |
|---|---|
Returns a SlicerItem object that represents the slicer button that is currently in focus for the specified slicer. Read-only. |
|
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only. |
|
Returns or sets the caption of the specified slicer. Read/write. |
|
Returns or sets the width, in points, of each column in the slicer. Read/write |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
Returns or sets whether the specified slicer can be moved or resized by using the user interface. Read/write. |
|
Returns or sets whether the header that displays the slicer Caption is visible. Read/write. |
|
Returns or sets the height of the specified slicer, in points. Read/write. |
|
Returns or sets the horizontal position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet. Read/write. |
|
Returns or sets whether the specified slicer can be modified when the sheet that contains it is protected. Read/write. |
|
Returns or sets the name of the specified slicer. Read/write. |
|
Returns or sets the number of columns in the specified slicer. Read/write. |
|
Returns the Worksheet object that represents the sheet that contains the slicer. Read-only. |
|
Returns or sets the height, in points, of each row in the specified slicer. Read/write. |
|
Returns the Shape object associated with the specified slicer. Read-only. |
|
Returns the SlicerCache object associated with the slicer. Read-only. |
|
Returns the SlicerCacheLevel object associated with the slicer. Read-only. |
|
Returns the type of the slicer cache – slicer or timeline. XlSlicerCacheType Read-only |
|
Returns or sets the style currently applied to the specified slicer. Read/write. |
|
The timeline-specific state of the Slicer. TimelineViewState Read-only |
|
Returns or sets the vertical position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet. Read/write. |
|
Returns or sets the width of the specified slicer, in points. Read/write. |