Having difficulty with Application.CommandBars("Queries and Connections").Visible = True

[johnny51981]

I have added in the following VBA into a number of my reports, in an effort to keep an eye on the updates so there are no errors:

Sub OpenQueriesPane()

Application.CommandBars("Queries and Connections").Visible = True
Application.CommandBars("Queries and Connections").Width = 700 'Change width as suits.

End Sub

I then have a main Sub ReportUpdate() that gets assigned to a button, this Sub is calling all of the processes that I need associated to the whole report update, and the Sub OpenQueriesPane() is always the first call in that whole report update. Here is an example of that:

Sub ReportUpdate()

    Call OpenQueriesPane
    Call RefreshData
    Call CloseExcel
    
End Sub

Problem is....it NEVER happens until all calls have been completed, if at all. Do I have anything incorrect, missing, or is this just a quirk that Excel has and I should stop trying to make it a thing?

This is on machine with 365.