This is my first question in this community. Sorry in advance if I make any formatting mistake.
I hope someone can help me with this: I have 4 buttons in my report, each one of them changes the way the user can view the charts.
1st button: "Maximizes" all charts, allowing the user to see only 1 chart at a time (in any given sheet).
2nd button: splits all charts and resizes them so the user can compare 2 charts. This button splits the charts vertically.
3rd button: splits all charts and resizes them so the user can compare 2 charts. This button splits the charts horizontally.
4th button: splits all charts and resizes them so the user can compare 4 charts.
So far, this works well but...
All charts have the option "Auto Minimize" turned ON. Yes, I can turn it off for every single chart but in case the user is viewing the info one chart at a time (with the first button), charts could get one in front of another.
What I want to know is:
Is there a property of the object to turn auto minimize on/off through macro?
So far I've tried things like:
set xObject = ActiveDocument.GetSheetObject("Tick_Ch_TickM") xObject.autominimize = false
But had no success.
Thanks in advance! I don't think I need to share the file, because all I want is to turn on/off autominimize for a chart, through a macro.