Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a Macro button to toggle between the object types Pivot Table and Line Chart within a single object. I would like to use this approach instead of use the fast access button in the object captions. Has anyone written a macro like this before? Thanks.
You can use a macro to access the properties of the sheet objects like this:
ActiveDocument.getsheetObject("CHxxx").GetProperties
Or the simplest way would be to have 2 charts - and hide/unhide them using a button action.