resize sheet size as per the active objects(unhidden)
Dear all,
I am stuck in a scenario where I have multiple charts in a sheet, all dispayed conditionally on button clicks.
In one case, there are 20 charts , and on other there are only two.So, when I have only two charts displyed, then also, the size of the sheet remains equal to the one where 20 are displyed , as in, the scroll bar appears as per the max size of sheet occupied by the objects
I belive this can be handled using some active sheet properties in a macro.
