conditional show on a container

[dseelam]

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

[MK9885]

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.

[dseelam]

arvind654

I don't want to get rid of other charts, want to activate chart A first once opened the sheet Tom

[vishsaggi]

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. ?

[dseelam]

Hello Vish

Select the Chart A in the container and save it and open the file again ?

this is temporary solution I want this chart to be active when ever I open sheet

Try to create a Bookmark and use on activate sheet trigger from sheet properties to activate that bookmark when sheet is opened. ?

don't want any bookmarks

Is there any way we can do this ?

[MK9885]

What do you mean by Active?

[vishsaggi]

What exactly happening when you trying to open the sheet, using my first option ?

[vishsaggi]

May be try this Macro from this link, as a work around ! By Laura.

How to set a default object to a container ?

[dseelam]

Vish,

I tried Laura technique but dint worked

thanks,

Dinesh 

[vishsaggi]

Is it ok to share a sample file if possible ?