Nota
L'accesso a questa pagina richiede l'autorizzazione. È possibile provare ad accedere o modificare le directory.
L'accesso a questa pagina richiede l'autorizzazione. È possibile provare a modificare le directory.
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.