Workbook.Excel4IntlMacroSheets Property

Excel Developer Reference

Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook. Read-only.

Syntax

expression.Excel4IntlMacroSheets

expression   A variable that represents a Workbook object.

Example

This example displays the number of Microsoft Excel 4.0 international macro sheets in the active workbook.

Visual Basic for Applications
  MsgBox "There are " & _
    ActiveWorkbook.Excel4IntlMacroSheets.Count & _
    " Microsoft Excel 4.0 international macro sheets" & _
    " in this workbook."

See Also