Is there a way get the selected sheet´s title and give that title to a object in the sheet?
I have a sheet named ABC and another named DEF
One object is visible on both sheets. I whant that object title to get its name from the selected sheet´s title. If sheet ABC is selected the object should be named ABC and if the DEF sheet is selected the object should be named DEF.
Maybe I miss something much easier, but you can surely use OnActivateSheet event trigger for each sheet (go to sheet properties, trigger) to set a variable accordingly and use the variable in your chart object.