Microsoft Office Tutorials and References
In Depth Information
16.1.2 Members that Affect the Display
ReplaceFormat
CellFormat
Rows
Range
RTD
RTD
Sheets
Sheets
ShortcutMenus
Menu
SmartTagRecognizers
SmartTagRecognizers
Speech
Speech
SpellingOptions
SpellingOptions
ThisCell
Range
ThisWorkbook
Workbook
Toolbars
Toolbars
Union
Range
UsedObjects
UsedObjects
Watches
Watches
Windows
Windows
Workbooks
Workbooks
WorksheetFunction
WorksheetFunction
Worksheets
Sheets
There are some points worth noting in Table 16-2 First, there are several members that begin with .
the word "Active." It should come as no surprise that these members return the corresponding
currently active object. For instance, the ActiveSheet member returns the currently active
worksheet or chart, depending upon which is active at the time. (Note that there is no Sheet object.
Sheets are either worksheets or stand-alone charts. We will discuss this issue in detail in Chapter
) .
Observe also that often the name of a member is the same as the name of the object that the
member returns. For instance, the AddIns property returns the AddIns collection, the Application
property returns the Application object, and the Windows property returns the Windows collection.
The notable exceptions to this rule are:
The ThisWorkBook property returns the Workbook object containing the currently
running code. One use of this property is in determining the location (complete path and
filename) of the workbook on the user's computer, which is done by writing:
ThisWorkbook.FullName
Several object properties, such as Cells, Columns, and Rows, return a Range object. This
is because there are no Cell, Column, or Row objects in the Excel object model. Instead,
each of these "objects" is actually a Range object. (Incidentally, a similar thing happens in
the Word object model. In particular, there are no Character, Word, or Sentence objects.
Rather, these are Range objects in the Word object model as well.)
16.1.2 Members that Affect the Display
There are several members that affect the display of certain items:
DisplayAlerts property (R/W Boolean)
 
 
Search JabSto ::




Custom Search