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