I currently have a command button that points to a specific spreadsheet. I
now require that when the command button is selected an option appears to
select either the GBP spreadsheet or USD spreadsheet.
Private Sub CommandButton13_Click()
Application.Goto Reference:="Top_10_Teams_by_Earnings"
End Sub

Additionally is it possible to go to a specific pivot table on the selected
spreadsheet and focus on the respective pivot table.