Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I disable subsequent sheets (Not hide) from being selected until I have selected a value in the multibox on the main sheet.
how are you selecting subsequent sheet?
is it via trigger activate sheet on text object.
if yes use two text boxes and conditionally hide show your text box
You can do that by hiding the Tabrow (see Settings->Document Properties->General->Hide Tabrow) and devising some other way of navigating your sheet list. For example, add a button to each sheet and enable/disable those buttons depensing on the number of selected values in a field. Or for a cleaner layout, add Text Boxes with Actions.
AFAIK the tabrow itself, when displayed, cannot be made ReadOnly.
Selecting the sheet by clicking on the Tabrow
This maybe the best option since I can't disable certain sheets from the Tabrow from being selected via mouse click.
This is what I was looking for! Top answer and a good technique to use!