With Excel 2000,
I need to retrieve chart title formula with vba, or a way to remove the title and later on, set it back as it was before I removed it.
Here is why:
I have a macro that copies all charts in the workbook into a powerpoint presentation.
It all works very well, using
Chart.CopyPicture xlScreen, xlPicture
but for visual reasons, the users want the graph title displayed outside the graph in the powerpoint presentation.
So my simple idea was to read the title, remove it, do the copy/paste, replace the title.
I found that I can get the title by using
However, if the title is based on a formula (like "=Page!$E$3") the above property returns the value, not the formula. So I can't set it back as it was before I remove it.
I also tried to remove the title using
, but then the whole ChartTitle object is cleared, along with all formating. So setting it back to true does not set it back as it was.
And unfortunately, the Application.Undo won't work in a macro.
Thanks for any help.