Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi, Use Activate Sheet as an action, add sheet name like SH02 in the sheetID
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
jst chk dis
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.
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 )