QuickAnalysis Object (Excel)

Office 2013

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

Version Added: Excel 2013

This sample illustrates using the QuickAnalysis.Hide Method (Excel) method of the QuickAnalysis object. In this example, the 1 argument specifies that, if displayed, the Conditional Formatting & Sparklines callouts are hidden.

ActiveWorksheet.QuickAnalysis.Hide(1)
Show:
© 2014 Microsoft