
What VBA instruction can be used to make the "Queries and Connections" appear on the screen and show the "Connections" tab?
Following VBA instruction will make the "Queries and Connections" menu appear on the screen, and by default it opens on the 'Queries' tab (or in case the user had manually opened it before, to the last tab that was selected by the user - which can be either one of both)
Application.CommandBars("Queries and Connections").Visible = True
What instruction can be used to make the menu switch to the 'Connections' tab?
Following command 'Application.CommandBars("Queries and Connections").Controls("Connections").Execute' generates run-time error 5 'invalid procedure call or argument'...
Thanks for your help.
Microsoft 365 and Office | Development | Other

Microsoft 365 and Office | Excel | For business | Windows
