QuickAnalysis.Hide method (Excel)
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for