T
thesaxonuk
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.
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.