Writing Excel Macros with VBA, 2nd Edition

Name

AllowEditRange Object

Synopsis

Path: Application  --  Range  --  Worksheet  --  Protection  --  AllowEditRanges - AllowEditRange
               

Object	Methods	Properties
AllowEditRange Object	ChangePassword(Password As String) Delete( ) Unprotect([Password] As Variant)	Range( ) As Range Title( ) As String Users( ) As UserAccessList
AllowEditRanges Object	Add(Title As String, Range As Range, [Password] As Variant) As AllowEditRange	Count( ) As Long Item(Index As Variant) As AllowEditRange

The AllowEditRange object allows a specified range of cells on a worksheet to be password protected from editing. Once a range has been protected in this way, and the entire worksheet has been protected, any attempt at editing cells in that range will require the password.

The AllowEditRanges collection object holds the current AllowEditRange objects.