1. I currently have a sheet with a number of objects in which only show when selected buttons are clicked
Adding you conditional show doesn't do anything as this table is already on show!
I am probably after this straight to maximise when any selection in fieldname in another chart is selected i.e.
active object minimise and target object maximise.
Hope this makes a little more sense?