Skip to content

Latest commit

 

History

History
41 lines (23 loc) · 983 Bytes

Excel.application.showquickanalysis.md

File metadata and controls

41 lines (23 loc) · 983 Bytes
title keywords f1_keywords ms.assetid ms.date ms.localizationpriority
Application.ShowQuickAnalysis property (Excel)
vbaxl10.chm133337
vbaxl10.chm133337
043d9523-1fbc-0afd-2adf-9775e71058c0
04/05/2019
medium

Application.ShowQuickAnalysis property (Excel)

Controls whether the Quick Analysis contextual user interface is displayed on selection. True means that the Quick Analysis button will show.

Corresponds to the Show Quick Analysis options on selection check box located on the File menu > Options > Excel Options > General tab. Read/write Boolean.

Syntax

expression.ShowQuickAnalysis

expression A variable that represents an Application object.

Property value

BOOL

Example

This example hides the Quick Analysis button on selection.

Application.ShowQuickAnalysis = False

[!includeSupport and feedback]