Active Sheet

[vignesh_s]

Hi all,

If i clik on one chart it should go to a diffierent sheet,can any one help hoe to achive ths

[cristianozilz]

Hi, Vignesh S

Look if this example help You.

In the Object Propriets, go to action and add the Activate Sheet.

[vignesh_s]

hi thanks for reply, i have pivot table if i clik on that it should go to different sheet nd presert sheet should disable

[thevingo]

Hi

1. you can put a transparent textbox with Action to Activate Sheet

2. or you can put a small icon/button/text for that & name it 'Click for Details' for user to understand

To hide the sheet, you can add another action as to Set a Variable & use that variable to conditional show/hide your sheet (Sheet Properties>General tab> Show Sheet>Conditional

[cristianozilz]

I don't know if this is possible,

But you can hide the sheet. and control all movimentation with text objects.

[el_aprendiz111]

Hi

1 exmp:

[Anonymous]

Try insert one object Text (Hide)  with action on top of the graphic object.

Transparent Text Object in Properties/Trigger you bild a action ....