Microsoft Office Tutorials and References
In Depth Information
Appendix G. New Objects in Excel XP
Appendix G. New Objects in Excel XP
Excel XP contains 37 new objects. This appendix presents a list, along with paths and a brief
description of each object. I also include a list of the object's members (omitting the almost
ubiquitous Application, Creator, and Parent properties).
AllowEditRange Object
Path: Application -- Range -- Worksheet -- Protection
-- AllowEditRanges - AllowEditRange
Object
Methods
Properties
Range() As Range
Title() As String
Users() As
UserAccessList
ChangePassword(Password As String)
Delete()
Unprotect([Password] As Variant)
AllowEditRange
Object
Count() As Long
Item(Index As
Variant) As
AllowEditRange
Add(Title As String, Range As Range,
[Password] As Variant) As
AllowEditRange
AllowEditRanges
Object
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.
AutoRecover Object
Path: Application - AutoRecover
Object
Properties
Enabled() As Boolean
Path() As String
Time() As Long
AutoRecover
The AutoRecover feature allows for the possible recovery of data if Excel XP stops responding (or
should I say when Excel XP stops responding?). The user can set the location in which Excel will
save AutoRecover files as well as the time between saving.
 
 
 
 
Search JabSto ::




Custom Search