Good day,
I know how to get all the objects of my application:
- loop in the sheets
- for each sheet, loop on the objects
But when an object is in an invisible sheet, I can't access it.
When I use a container object, I usually give it 2 (or more) graphs that I "hide" in an invisible sheet.
So, in can't access any of this graphs with a macro.
Is there a solution ?
I don't succeed to change the "ShowAllSheetsAndObjects" with the API...