Share via


ExcelWebRenderer.ShowWorkbookParameters Property

Shows or hides the workbook parameters pane.

Namespace:  Microsoft.Office.Excel.WebUI
Assembly:  Microsoft.Office.Excel.WebUI (in Microsoft.Office.Excel.WebUI.dll)

Syntax

'Declaration
<WebBrowsableAttribute(True)> _
<WebPartStorageAttribute(Storage.Shared)> _
<PersonalizableAttribute(PersonalizationScope.Shared)> _
Public Property ShowWorkbookParameters As Boolean
    Get
    Set
'Usage
Dim instance As ExcelWebRenderer
Dim value As Boolean

value = instance.ShowWorkbookParameters

instance.ShowWorkbookParameters = value
[WebBrowsableAttribute(true)]
[WebPartStorageAttribute(Storage.Shared)]
[PersonalizableAttribute(PersonalizationScope.Shared)]
public bool ShowWorkbookParameters { get; set; }

Property Value

Type: System.Boolean

Remarks

When this property is set to true and workbook parameters exist in the workbook, a collapsible pane is shown in Excel Web Access. Users can edit these parameters. If this property is disabled, the pane will not be shown even if workbook parameters exist in the workbook.

If the AllowParameterModification property is disabled, the ShowWorkbookParameters property will be disabled, and the user cannot enable it. Additionally, if the AllowInteractivity option is disabled, the AllowParameterModification property will become disabled, causing the ShowWorkbookParameters property to become disabled.

See Also

Reference

ExcelWebRenderer Class

ExcelWebRenderer Members

Microsoft.Office.Excel.WebUI Namespace