Edit

Share via

QuickAnalysis.Hide method (Excel)

  • Article

Hides specific members of the Analysis Lens user interface.

Syntax

expression.Hide (XlQuickAnalysisMode)

expression A variable that represents a QuickAnalysis object.

Parameters

Name Required/Optional Data type Description
XlQuickAnalysisMode Optional XlQuickAnalysisMode Indicates for which top level button the callout user interface is displayed. Can be one of the XlQuickAnalysisMode constants.

Return value

VOID

Remarks

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

  • If missing or set to 0 = Hide all buttons

  • 1 = If showing, hide the Conditional Formatting and Sparklines buttons

  • 2 = If showing, hide the Charts button

  • 3 = If showing, hide the Suggested Views button

  • 4 = If showing, hide the Totals button

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.