How do I reference Chart Sheets?
Posted: Tue Sep 19, 2006 3:59 pm
I am working with a workbook with 3 normal worksheets and one chart sheet (a chart that is not embedded in a worksheet).
How can I reference the Chart sheet? XLS.Sheets.Count = 3 (the number of normal worksheets). For an embedded Chart, you can use the Charts property of TSheet, but this won't work for a Chart sheet.
I would like to make the workbook select only the Chart sheet tab so that the Chart is shown when the workbook is opened in Excel, but I can't do this using XLS.Workbook.SelectedTab, which only seems to recognize normal worksheets.
How can I reference the Chart sheet? XLS.Sheets.Count = 3 (the number of normal worksheets). For an embedded Chart, you can use the Charts property of TSheet, but this won't work for a Chart sheet.
I would like to make the workbook select only the Chart sheet tab so that the Chart is shown when the workbook is opened in Excel, but I can't do this using XLS.Workbook.SelectedTab, which only seems to recognize normal worksheets.