Can We Write Macro Script In Chart Object Expression

[#1]

1) This state shows error when i written below statement in Chart Property->General Tab->

Window Title->Expression

if(ActiveDocument.GetSheetObject("CH01").IsMaximized,'Sales Object',

'Sales According Months')

i want to know its possible to write or can we use macro script in chart object expression.

2) Basically i want to do change chart object window name when chart object is minimize or maximize.

Please guide me

[#2 · Accepted solution]

Hi

The quick answer is NO. You can't use macros anywhere outside of the "Edit module" window.
You can use a chart title instead, or text in chart. That way the window title will remain the same but obviously the chart title won't be shown when the chart is minimized.

/Fredrik

[#3]

Ok fine and Thanks.