WorkbookBase.Excel4IntlMacroSheets Property
Gets a Microsoft.Office.Interop.Excel.Sheets collection that represents all the Microsoft Office Excel 4.0 international macro sheets in the workbook.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property Excel4IntlMacroSheets As Sheets
public Sheets Excel4IntlMacroSheets { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Sheets
A Microsoft.Office.Interop.Excel.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 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
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);
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.