Queries and Connections Pane via VBA?

[Matt Allington]

I would like to be able to control the display and hiding of the Query and Connections pane in Excel 2016 (Power Query). I have tried to find the object using the macro recorder but the open/close event doesn't get recorded. Can anyone tell me if this is controllable, and if so, how?

Thanks

Matt

 

[macfuller]

I have version 2102 Build 13801.20864 64-bit. The .Visible property still works but the .Width property doesn't change anything. Just happened in the last set of updates.

 

[Bagnon]

I have version 2102 Build 13801.20864 64-bit. The .Visible property still works but the .Width property doesn't change anything. Just happened in the last set of updates.

I had to remove the .Width part for it work for me. If you record a macro changing the width, it does record it, but that code will not work when you run it back in connection with .visible.

 

[MeatyCheesy]

Does anyone have run-time issue related to using this code? I will get a run-time error if I open a workbook and run this code. If I interactively click on Open Queries (which opens the Workbook queries panel manually) and then run this code; no run-time error occurs.

Sub OpenQueriesPane()
Application.CommandBars("Queries and Connections").Visible = True
End Sub