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.
Thanks in advance.