Name

alloweditranges.Add(Title, Range, [Password])

Synopsis

Creates and names a range that allows user-level permissions. Returns an AllowEditRange object.

Argument

Settings

Title

The name for the range. This name must be unique among the edit ranges in the worksheet.

Range

The Range object to allow edits on.

Password

The password the users not in the user-access list must enter before they can edit the range. Users that are in the range’s user-access list are not prompted for the password.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.