Microsoft Office Tutorials and References
In Depth Information
Figure G-1. The Error Checking tab
Count() As Long
Item(Index As Variant) As Object
UsedObjects
The documentation for the UsedObjects collection object is incredibly bad, even by Microsoft
standards, which is saying a lot. It gives absolutely no clue as to what used objects might be, but it
does tell us how to count the number of used objects!
If you open a brand new workbook (with the default three empty worksheets), then the code:
Application.UsedObjects.Count
returns the number 7, so whatever is used object might be, there are 7 of them in a new workbook.
After some experimentation and much frustration, I conclude that if Microsoft does not consider it
worth spending time to write even a sentence explaining used objects, then it is probably not
worth your time or mine to try to figure it out.
UserAccessList andUserAccess Objects
Path: Application -- Range -- Worksheet -- Protection
-- AllowEditRanges --
AllowEditRange -- UserAccessList - UserAccess
Object
Methods
Properties
AllowEdit() As Boolean
Name() As String
Delete()
UserAccess
Add(Name As String, AllowEdit As
Boolean) As UserAccess
DeleteAll()
Count() As Long
Item(Index As Variant)
As UserAccess
UserAccessList
UserAccess objects allow certain users to access a protected range without requiring the password.
Watch Object
Path: Application -- Watches - Watch
Object
Methods
Properties
Delete()
Source() As Variant
Watch
Add(Source As Variant) As Watch
Delete()
Count() As Long
Item(Index As Variant) As Watch
Watches
 
 
Search JabSto ::




Custom Search