Class QuickAnalysis (Excel VBA)

Enables single-click access to data analysis features such as formulas, conditional formatting, sparklines, tables, charts, and PivotTables.

Hide

Hides specific members of the Analysis Lens user interface.

When the argument is set to any one of the following options, the resulting user interface is hidden:

Syntax : expression.Hide (XlQuickAnalysisMode)

XlQuickAnalysisMode: Indicates for which top level button the callout user interface is displayed. Can be one of the XlQuickAnalysisMode constants.

Parent

Returns an object that represents the parent object of the specified QuickAnalysis object. Read-only.

Show

Displays specific members of the Analysis Lens user interface.

Syntax : expression.Show (XlQuickAnalysisMode)

XlQuickAnalysisMode: Indicates for which top level button the callout user interface is displayed. Can be one of the XlQuickAnalysisMode constants.