Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have two Charts A&B in a Container, want to activate only chart A when ever I open sheet
thanks,
Dinesh
Message was edited by: Dinesh Reddy Seelam
It worked for me. Check this file attached? A table box is always highlighted when you come back from an other sheet or close and open the document. Added sheet level and document level trigger here. Let me know if you get stuck.
View solution in original post
Unlink these charts on Sheet TOM, so that it won;t effect the rest of the charts in other sheet container.
And you can remove the charts B,C,D,E,F and G from your Sheet TOM or Give a conditional expressions for B,C,D,E,F and G.
If you just wanna see Chart A then unlink other charts and remove them from container.
arvind654
I don't want to get rid of other charts, want to activate chart A first once opened the sheet Tom
Did you try this ?
Select the Chart A in the container and save it and open the file again ?
OR
Try to create a Bookmark and use on activate sheet trigger from sheet properties to activate that bookmark when sheet is opened. ?
Hello Vish
this is temporary solution I want this chart to be active when ever I open sheet
don't want any bookmarks
Is there any way we can do this ?
What do you mean by Active?
What exactly happening when you trying to open the sheet, using my first option ?
May be try this Macro from this link, as a work around ! By Laura.
How to set a default object to a container ?
Vish,
I tried Laura technique but dint worked
Is it ok to share a sample file if possible ?
