Applies To
Application Object, Workbook Object.
Description
Accessor. Returns an object that represents a Microsoft Excel 4.0 international macro sheet (a Worksheet object, Syntax 1) or a collection of all Microsoft Excel 4.0 international macro sheets (a Worksheets object, Syntax 2) in the workbook. Read-only.
Syntax 1
object.Excel4IntlMacroSheets(index)
Syntax 2
object.Excel4IntlMacroSheets
object
Optional for Application, required for Workbook. The object that contains Microsoft Excel 4.0 international macro sheets.
index
Required for Syntax 1. The name or number of the Microsoft Excel 4.0 international macro sheet to return.
Remarks
Using this method with no object qualifier is a shortcut for ActiveWorkbook.Excel4IntlMacroSheets.
See Also
Excel4MacroSheets Method, Worksheets Method.
Example
This example displays the number of Microsoft Excel 4.0 international macro sheets in the active workbook.
MsgBox "There are " & ActiveWorkbook.Excel4IntlMacroSheets.Count & _
" Microsoft Excel 4.0 international macro sheets in this workbook."