Excel4MacroSheets Property 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."