is there a way of clicking on sheet properties, to get the object id list then clicking somehow on the individual object id and go directly to that chart/text box/etc..? thanks in advance
you can use Button , In Button Properties ->Actions-> Activate Object
As far as i know, it is not possible to go directly to charts/text box form Sheet properties. You can also try using Sheet level Triggers.