1 Reply Latest reply: Oct 5, 2010 8:47 AM by lawrencem RSS

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

      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.