VBA Dropdown move between sheets

[nave88]

Hi I'm using a a dropdown to jump between sheets, but the problem is if I jump from one sheet to another and want to jump back it gets stuck, then I have to pick a different sheet. Is there a way to fix that?

Sub MovetoSheet()
Dim dd As DropDown


Set dd = ActiveSheet.Shapes("Drp_Dwn").OLEFormat.Object
shtnametogo = dd.List(dd.ListIndex)
'Worksheets(ActiveSheet.Name).Shapes("Drp_Dwn").Value
Worksheets(shtnametogo).Activate
Range("A1").Activate
End Sub

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1049546-vba-move-between-sheets-drop-down.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.