1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

VBA - Queries & Connections Pane Visible

I have a need to make the Queries & Connections Pane visible to monitor any issues that may arise when refreshing the PQs.

Until an Update made by Microsoft some time in 2025, they have removed that in some way…I don’t know how to say it…but it is known to no longer work. Anyway. Anyone have any solution to achieve the same/similar results?

Sub OpenQueriesPane()

Application.CommandBars(“Queries and Connections”).Visible=True Application.CommandBars(“Queries and Connections”).Width=400 ‘Change width as suits. 

End Sub

And adding DoEvents anywhere does nothing.

TIA

submitted by /u/Chemical-Jello-3353
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#real-time data collaboration
#no-code spreadsheet solutions
#Queries & Connections Pane
#VBA
#Visible
#OpenQueriesPane
#Application.CommandBars
#refreshing PQs
#Excel
#monitor issues
#Microsoft Update
#CommandBars
#solution
#PQs
#Width
#DoEvents
#Change width