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