Button variable?

[Anonymous]

I created a button on main sheet, want to go to sheet 10 when i click this button. how should i assign a variable to do this?

[stabben23]

Hi, Use Activate Sheet as an action, add sheet name like SH02 in the sheetID

[Digvijay_Singh]

If you want to do using variable, see attached.

Create variable SheetNo and use this in the action activate sheet.

Button-<Action-->Layout-->activate sheet

[Chanty4u]

jst chk dis

SHEETS HIDE AND SHOW

[jagan]

Hi,

Try like this by adding an action to the button like below

Button Properties -> Action -> Layout -> Activate Sheet

in that give the Sheet ID of Sheet 10.

Hope this helps you.

Regards,

jagan.

[avinashelite]

Try like this

Go to button Properties> action > Layout >Activate Sheet > then enter your sheet id here (to get the sheet id , go to sheet properties >general> sheet Id )