Code to make the Data / Queries & Connection window visible (and a way to close it)

gheyman

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
2,341
Office Version
  1. 365
Platform
  1. Windows
I would like to have the Data / Queries & Connection window visible so that the user can see the tables being refreshed. Is it possible to have code that would open it if its not already open?

Thanks for the help
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
You must log in or register to reply here.

Similar threads

R
  • Question
Is there a way to open a file that Power Query has locked as Read-Only?
Replies
0
Views
91
rcrumbliss
R
C
  • Question
Hiding Sheets during the Before_Close Event
2
Replies
10
Views
292
Jaafar Tribak
Jaafar Tribak
E
  • Question
Checking for NamedRange in a worksheet in a closed workbook (using DAO connection)?
Replies
0
Views
148
EdNerd
E
D
  • Question
Saving workbook "hides" macros
Replies
2
Views
373
dotsent
D
K0st4din
  • Question
Close workbook when changing ip or mas address
Replies
5
Views
123
Logit
Logit

Forum statistics

Threads
1,214,965
Messages
6,122,499
Members
449,089
Latest member
Raviguru

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top