Slicer Members (Excel)

Represents a slicer in a workbook.

Methods

Name	Description
Copy	Copies the specified slicer to the clipboard.
Cut	Cuts the specified slicer and copies it to the clipboard.
Delete	Deletes the slicer and removes it from the associated Slicers collection.

Properties

Name	Description
ActiveItem	Returns a SlicerItem object that represents the slicer button that is currently in focus for the specified slicer. Read-only.
Application	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.
Caption	Returns or sets the caption of the specified slicer. Read/write.
ColumnWidth	Returns or sets the width, in points, of each column in the slicer. Read/write
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
DisableMoveResizeUI	Returns or sets whether the specified slicer can be moved or resized by using the user interface. Read/write.
DisplayHeader	Returns or sets whether the header that displays the slicer Caption is visible. Read/write.
Height	Returns or sets the height of the specified slicer, in points. Read/write.
Left	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.
Locked	Returns or sets whether the specified slicer can be modified when the sheet that contains it is protected. Read/write.
Name	Returns or sets the name of the specified slicer. Read/write.
NumberOfColumns	Returns or sets the number of columns in the specified slicer. Read/write.
Parent	Returns the Worksheet object that represents the sheet that contains the slicer. Read-only.
RowHeight	Returns or sets the height, in points, of each row in the specified slicer. Read/write.
Shape	Returns the Shape object associated with the specified slicer. Read-only.
SlicerCache	Returns the SlicerCache object associated with the slicer. Read-only.
SlicerCacheLevel	Returns the SlicerCacheLevel object associated with the slicer. Read-only.
Style	Returns or sets the style currently applied to the specified slicer. Read/write.
Top	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.
Width	Returns or sets the width of the specified slicer, in points. Read/write.