I have hidden all but 1 sheet in my workbook. Depending on the selection in cell E5 (I have created a validation list) on this sheet I would like the sheet with the same name to appear and to become the active sheet once the okay button is clicked.
If the user then manually selects the first sheet again I would like the sheet that appeared to hide itself again.
Is this possible at all?
If the user then manually selects the first sheet again I would like the sheet that appeared to hide itself again.
Is this possible at all?