Sdílet prostřednictvím

WorkbookBase.Excel4IntlMacroSheets Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets a Sheets collection that represents all the Microsoft Office Excel 4.0 international macro sheets in the workbook.

public:
 property Microsoft::Office::Interop::Excel::Sheets ^ Excel4IntlMacroSheets { Microsoft::Office::Interop::Excel::Sheets ^ get(); };
public Microsoft.Office.Interop.Excel.Sheets Excel4IntlMacroSheets { get; }
member this.Excel4IntlMacroSheets : Microsoft.Office.Interop.Excel.Sheets
Public ReadOnly Property Excel4IntlMacroSheets As Sheets

Property Value

Sheets

A Sheets collection that represents all the Microsoft Office Excel 4.0 international macro sheets in the workbook.

Remarks

The following code example iterates through every Microsoft.Office.Interop.Excel.Worksheet returned by the Excel4IntlMacroSheets property and writes the code name of each worksheet to the debug output.

This example is for a document-level customization.

private void DisplayExcel4IntlMacroSheets()
{
    Excel.Sheets sheetsCollection = this.Excel4IntlMacroSheets;
    for (int i = 1; i < sheetsCollection.Count; i++)
    {
        Excel.Worksheet sheet = (Excel.Worksheet)sheetsCollection[i];
        System.Diagnostics.Debug.WriteLine(sheet.CodeName);
    }
}

Private Sub DisplayExcel4IntlMacroSheets()
    Dim sheetsCollection As Excel.Sheets = Me.Excel4IntlMacroSheets
    Dim i As Integer
    For i = 1 To sheetsCollection.Count
        Dim sheet As Excel.Worksheet = _
            CType(sheetsCollection(i), Excel.Worksheet)
        System.Diagnostics.Debug.WriteLine(sheet.CodeName)
    Next i
End Sub

Applies to