AllowEditRange Members (Excel)

GitHub-Mark-64px

Contribute to this content

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

Represents the cells that can be edited on a protected worksheet.

Methods

Name

Description

ChangePassword

Changes the password for a range that can be edited on a protected worksheet.

Delete

Deletes the object.

Unprotect

Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.

Properties

Name

Description

Range

Returns a Range object that represents a subset of the ranges that can be edited edited on a protected worksheet.

Title

Returns or sets the title of the range of cells that can edited on a protected sheet. Read/write String.

Users

Returns a UserAccessList object for the protected range on a worksheet.