I have a dropdown that list the names of spreadsheets stored in a tab (sheet 2). Once the name is selected in launches to that sheet. I would like to not assign a macro to the dropdown and assign it to the button to control when it launches. What are your suggestions to do this?
this is what i am currently using for my code:
With ActiveSheet.DropDowns("Drop Down 1")
If .ListIndex > 0 Then