Hoping someone can help me
Im trying to create a workbook that from the first page (worksheet) a user can select predertimend options from a dropdown (This i understand how to do), and based on the selections, This will be in a range of cells IE. A1 to A10
I will have worksheets hidden but named the same as these selection, I just want to have the corresponding worksheet unhide when selected. I have a code to do it with one cell only but i need it in a range of cells. this is what i have
Private Sub worksheet_change(ByVal target As Excel.Range) Dim ws As Worksheet For Each ws In Worksheets If ws.Name <> "Sheet1" And ws.Name <> Worksheets("Sheet1").Range("A1").Value Then ws.Visible = False End If If ws.Name = Worksheets("Sheet1").Range("A1").Value Then ws.Visible = True End If Next ws End Sub
I thought i would try replacing ("A1") with ("A1:A10") but that didnt work I received an error message, Mind you im a little new to all this stuff.
Any help would be appreciated.