AllowEditRange Object Members

Excel Developer Reference

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

Methods

  Name Description
Bb255811.methods(en-us,office.12).gif ChangePassword Changes the password for a range that can be edited on a protected worksheet.
Bb255811.methods(en-us,office.12).gif Delete Deletes the object.
Bb255811.methods(en-us,office.12).gif Unprotect Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.

Properties

  Name Description
Bb255811.properties(en-us,office.12).gif Range Returns a Range object that represents a subset of the ranges that can be edited edited on a protected worksheet.
Bb255811.properties(en-us,office.12).gif Title Returns or sets the title of the range of cells that can edited on a protected sheet. Read/write String.
Bb255811.properties(en-us,office.12).gif Users Returns a UserAccessList object for the protected range on a worksheet.