How do I reference Chart Sheets?

John_M · Post by **John_M** » 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.

Post by **larsa** » Tue Sep 26, 2006 5:32 am

Hello

For the moment it's not possible to set the selected tab for (sheet) charts.

Lars Arvidsson