WorksheetView Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

An object that defines the behavior of a single worksheet view.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

DisplayFormulas

Returns or sets if formulas should be displayed or hidden in the current worksheet view. Read/write Boolean.

DisplayGridlines

True if gridlines are displayed. Read/write Boolean.

DisplayHeadings

True if both row and column headings are displayed; False if no headings are displayed. Read/write Boolean.

DisplayOutline

True if outline symbols are displayed. Read/write Boolean.

DisplayZeros

True if zero values are displayed. Read/write Boolean.

Parent

Returns the parent object for the specified object. Read-only.

Sheet

Returns the sheet name for the specified WorksheetView object. Read-only.