Find the name of a chart sheet

**brownsl** · 04-30-2009, 10:30 AM

I have a spreadsheet containing quite a few worksheets with some of them being chart sheets. I have a summary sheet at the front of the spreadsheet that lists the sheets. On this summary page I have the names of the various worksheets automatically populated in the cells using the following

Please Login or Register  to view this content.

This way if a sheet's name changes this summary sheet changes also. This works well for normal worksheets but does not work at all for the chart sheets since there are no A1 cells on these sheets. Is there a way to automatically get the name of the chart sheets?

Shawn

**brownsl** · 05-01-2009, 10:11 PM

Maybe there is no solution to this. It seems like it would somehow be possible. Frustrating that chart sheets appear to be so different from a regular ol' worksheets.

Shawn

**Andy Pope** · 05-02-2009, 06:36 AM

I think code is the only way to do this. Write your own UDF

=SheetTabName("Chart1")

Please Login or Register  to view this content.

**brownsl** · 05-04-2009, 11:08 AM

Thanks for the help! That works except if I change the name of the chart sheet the name in the summary sheet does not update automatically. Is there a way to have just this function fire automatically maybe whenever the summary page is viewed?

I use the names on the summary sheet as links to the various sheets in the workbook. So, if someone double-clicks the name of the chart sheet on the summary sheet that chart sheet becomes active. The way it works now if someone changes the name of the chart sheet and goes back to the summary page the name has not been updated and if double-clicked an error occurs.

Thanks again,

Shawn