Boris Smits
09-20-2019, 08:44 AM
E.g.
I'm in worksheet "Main" (all other sheets are hidden), in Cell A1 I type "SHEET 1", in A2 I type "SHEET 2" and in A3 I type "SHEET 3". How can I unhide SHEET 1, SHEET 2 en SHEET 3 with a command button (in VBA)? Of course if in A1 is typed "SHEET 4" then SHEET 4 must be unhidden.
So the value that is put in in cell A1, A2 en A3 must be used to open the corresponding Worksheets.
Hope someone can help me, I've searched for hours couldn't find the wright answer. Thank you!
I'm in worksheet "Main" (all other sheets are hidden), in Cell A1 I type "SHEET 1", in A2 I type "SHEET 2" and in A3 I type "SHEET 3". How can I unhide SHEET 1, SHEET 2 en SHEET 3 with a command button (in VBA)? Of course if in A1 is typed "SHEET 4" then SHEET 4 must be unhidden.
So the value that is put in in cell A1, A2 en A3 must be used to open the corresponding Worksheets.
Hope someone can help me, I've searched for hours couldn't find the wright answer. Thank you!