Export (0) Print
Expand All
Expand Minimize

Application.ShowQuickAnalysis Property (Excel)

Office 2013

Controls whether the Quick Analysis contextual user interface is displayed on selection. TRUE means the Quick Analysis button will show. Corresponds to the Show Quick Analysis options on selection checkbox located in the File menu, Options, Excel Options, and then General tab. Read/Write. Boolean.

Version Added: Excel 2013

expression .ShowQuickAnalysis

expression A variable that represents an Application object.

This example hides the Quick Analysis button on selection.

Application.ShowQuickAnalysis = False
Show:
© 2015 Microsoft