A sheet whose content is carried but not modeled: a chart sheet, an Excel 4.0 macro sheet or an
Excel 5 dialog sheet.
Remarks
It is a tab like any other: it can be renamed, moved, hidden, colored, selected and deleted, and it
counts in SHEETS(), SHEET() and 3-D references. What it holds is kept as it was read and written
back unchanged. It has no cells, so a reference to one (Chart1!A1) is #REF!; for a macro sheet
that differs from Excel, which reads its cells.
Renames and moves are not followed inside it: a chart's series formulas and a macro sheet's
formulas keep the names they were written with.
A sheet whose content is carried but not modeled: a chart sheet, an Excel 4.0 macro sheet or an Excel 5 dialog sheet.
Remarks
It is a tab like any other: it can be renamed, moved, hidden, colored, selected and deleted, and it counts in
SHEETS(),SHEET()and 3-D references. What it holds is kept as it was read and written back unchanged. It has no cells, so a reference to one (Chart1!A1) is#REF!; for a macro sheet that differs from Excel, which reads its cells.Renames and moves are not followed inside it: a chart's series formulas and a macro sheet's formulas keep the names they were written with.
See
Interface
IOpaqueSheet