Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using one multibox to show four different values - 1,2,3,4.
Now on selection of each value i want to show respective sheets. e.g. on selection 1, sheet1 should be visible and on selection 2, sheet 2.
Can anybody help me with the MACRO for it.
Thanks.
Hello,
If you want to show only that sheet which value is selected, you can go to the Sheet properties, General, Show Sheet, Conditional, SELECTION = 1, where SELECTION is the name of the field that stores those numbers 1, 2, 3, 4 and 1 is the number of each sheet.
Without any selection, you won't see any sheets, once you select one value, the sheets will display accordingly.
Is that what you need?