Action on Buttons to active sheets

[dhavalvyas]

Hi,

I have 5 sheets in my dashboard,as i want 5 buttons for 5 different sheets.while preesing1 it should open sheet1 similarly pressing 2 it should open sheet 2.

So how can do this can  anyone suggest any solution ?

[vishsaggi]

Create 5 buttons and in Actions tab click actions and Layout -> Activate sheet

Then in activate sheet give the sheet name.

Like below:

[Siva_Sankar]

Hi Dhaval Vyas.

Find the attached example.