Slicer.ActiveItem Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns a SlicerItem object that represents the slicer button that is currently in focus for the specified slicer. Read-only.

public:
 property Microsoft::Office::Interop::Excel::SlicerItem ^ ActiveItem { Microsoft::Office::Interop::Excel::SlicerItem ^ get(); };

public Microsoft.Office.Interop.Excel.SlicerItem ActiveItem { get; }

Public ReadOnly Property ActiveItem As SlicerItem

Property Value

SlicerItem

Remarks

The ActiveItem property will return a SlicerItem object when the specified slicer has focus and the active control is a button within the slicer (for example, the user can navigate the buttons within the slicer with the keyboard in this state).

The ActiveItem property will return Nothing (a null reference (Nothing in Visual Basic) in C#) under the following circumstances:

• The specified slicer does not have focus (is not selected or active).
• The specified slicer has focus and the whole slicer itself is selected (for example, the user can move the whole slicer around using the keyboard in this state).
• The specified slicer has focus and the active control is the Clear Filter button in the header of the slicer.