Name

UserAccessList andUserAccess Objects

Synopsis

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

Object

Methods

Properties

UserAccess

  • Delete( )

  • AllowEdit( ) As Boolean

  • Name( ) As String

UserAccessList

  • Add(Name As String, AllowEdit As Boolean) As UserAccess

  • DeleteAll( )

  • Count( ) As Long

  • Item(Index As Variant) As UserAccess

UserAccess objects allow certain users to access a protected range without requiring the password.

Get Writing Excel Macros with VBA, 2nd Edition 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.

Start your free trial