Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone,
I am trying to open another sheet on the existing sheet by putting an action to a text box ,
Is it possible? i need your help,
Like i have a sheet named sheet1 which contains a button or a text box named open_sheet_2
so by clicking this button or text box i want to open another sheet named sheet2 over the existing sheet.
Thanks and regards.
Yes it is possible. go to Button properties->actions->add->Layout->Activate sheet and in sheet ID give the ID of the sheet which you would like to activate.
It will take you to thatsheet.
Hope that helps.
Yes it is possible. go to Button properties->actions->add->Layout->Activate sheet and in sheet ID give the ID of the sheet which you would like to activate.
It will take you to thatsheet.
Hope that helps.
Hi,
Yes you can to this with button action or text action -> Properties -> Action ->Add ->Layout->Active next sheet or you can use Active sheet ( i.e here give Sheet ID which you want to active).
Note:
- If you have same design for entire sheets in your application,you can hide all sheets and play around button or text objects actions. For this you need to, Document Properties -> Check Hide Tabrow.
- You can see only activated sheet every time when you click on button or text object action.
Thanks,
Jagan