Hello there,
I would like to know, if possible, what the correct procedure and method is in order to perform the following tasks:
1) For a dropdown menu (of approx 40 listed variables) to contain some sort of "link" to a corresponding hidden sheet.
2) The aforementioned "link" to be activated upon selection from the dropdown list (possibly with a macro-enabled button).
3) The hidden sheet to automatically be selected and appear as the "current" sheet.
4) Upon selection of another variable, the procedure to be reversed (previous selection is hidden) and "new" selection in unhidden/selected/visible as the current sheet.
Thanks very much in advance and look forward to hearing from anyone on here!
Kostas
I would like to know, if possible, what the correct procedure and method is in order to perform the following tasks:
1) For a dropdown menu (of approx 40 listed variables) to contain some sort of "link" to a corresponding hidden sheet.
2) The aforementioned "link" to be activated upon selection from the dropdown list (possibly with a macro-enabled button).
3) The hidden sheet to automatically be selected and appear as the "current" sheet.
4) Upon selection of another variable, the procedure to be reversed (previous selection is hidden) and "new" selection in unhidden/selected/visible as the current sheet.
Thanks very much in advance and look forward to hearing from anyone on here!
Kostas