How to create a navigation buttons to direct to an specific sheet?

[memela]

Hi, all

How do u create a button that displays a sheet when clicked?

Thank you!

[Miguel_Angel_Baeyens · Accepted solution]

• Step 1: create a new sheet
• Step 2: create a variable to show or hide that sheet, for example, vSheet1Show.
• Step 3: use the button object or text object and set an action to change the value of that variable, such as
  =If($(vSheet1Show) = 1, 0, 1)
  To create the action right click on the button or text object > Properties > Action > Add > External > Set Variable
• Step 4: on the new sheet, right click on its background > Properties > General > Show Sheet > Conditional > in the textbox type
  =$(vSheet1Show)
  and hit Apply
• Step 5: go back to the original sheet, and click on the button a couple of times to confirm it behaves as expected.
• Step 6: to make the button a bit more "intelligent", you can dynamically change the text of the button itself, using an expression such as
  =If($(vSheet1Show), 'Hide', 'Show')
  by right clicking on the object > Properties > General > Text

Attaching dummy sample for perusal.