User AccessList Collection Object

Represents a list of users who have access to a protected range on a worksheet. This object can be accessed via the AllowEditRange object after it has been created. Use the Add method of this object to add a user to the list, which contains an argument that determines whether or not they need a password to access the range.

Note that the password is set using the ChangePassword method of the AllowEditRange object. This means that all of the users for an AllowEditRange use the same password. Note that this collection only has Count and Item properties.

0 0

Post a comment