Share via


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.