Get selected sheet title

[#1]

Hi!

Is there a way get the selected sheet´s title and give that title to a object in the sheet?

For example:

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.

Possible?

Best regards,

Dave

[swuehl]

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.

[#3]

I tried and it works well. Better would be if it could get the sheet name direct, but this will work for now.

Many thanks! Fast answer!!

/Dave