Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
How to hide the sheets using buttons?
you can use variables om conjuction with actions
1) for each sheet define Show Conditional: if (vShowSheet=1)
2) create button with Action External Set variable
Variable vShowSheet with Value 1 or 0 (dependng if you want to Show sheet = 1 or hide sheet = 0)
you Need a variable for every sheet or sheet Group you want to Show/hide
see attachment, button sheet2 and sheet3 and back to sheet1
using layout conditions with variables we can achieve the same.
more over if we can hide the sheets by default will make the look and feel much better.
Settings->Document Properties->General<tab>->Hide tab row(Check box)