Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to navigate among the sheets by using button or text?
To the button / text box add an action :
Action Type Layout
Action Activate Sheet
Each sheet has a code "SH<number>" you can find on the General tab of the sheet properties. That can be used to jump to that sheet using the action mentioned by Bill.
You can also use the actions Activate Next Sheet and Activate Previous Sheet on buttons or text objects. Often used on buttons with arrows on them.
look this
Thanks for the reply
Hi,
Create New Button --> Give it a name --> Action Tab --> Add Action --> Select --> Layout --> Activate Sheet --> and Provide Sheet ID.
Ex: SH02
Regards
ASHFAQ
If you get your desire result close this thread by choosing correct or helpful or assumed answer.