Set charts visibility to "Always" using macro (Chart Properties -> Layout tab -> Show groupbox -> Always)

[#1]

Hi All,

Is there any event to know whether an object is pasted onto another sheet once its copied from a sheet?

Something like : onPaste() event

How can we set the visibility of a chart to "Always" using a macro? i.e the two radio buttons in 'Show' groupbox under Layout tab in a charts property.

Chart Properties -> Layout tab -> Show groupbox -> Always, Conditional.

I need to retrieve the pasted charts properties, set the charts visibility to "Always" rather than "Conditional", so that the chart is visible always on the sheet.

Is there any other alternative to using macros in this case? Because I need to set the properties runtime based on user's events.

Any suggestions?

Thanks in advance.

[#2]

I figured this out, its easy but took some considerable amount of time:

set

cp=chart.getproperties

cp.graphlayout.Frame.Show.Always=

True

chart.setproperties cp