Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook. Read-only.
For information about returning a single member of a collection, see Returning an Object from a Collection.
Remarks
Using this property with the Application object or without an object qualifier is equivalent to using ActiveWorkbook.Excel4MacroSheets
.
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."