Silent Treatment - how to hide excel query results

dmcgimpsey

Active Member
Joined
Mar 30, 2004
Messages
268
Hi there -

Again, great forum.

I am retrieving Access data to a spot on my worksheet, and I want to hide the activity from the user.

For example: when the query executes, it repositions the cursor to the H4 cell location (which is off the primary menu) and then it executes the query, and the data is returned.

I would like to have this action hidden from the user, and done kinda in the background

I appreciate your help
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

staticbob

Well-known Member
Joined
Oct 7, 2003
Messages
1,079
Hi dmcgimpsey,

Have you tried using...

Application.screenupdating = False
'Your code here
Application.screenupdating = True

That should at least stop the user seeing the action on screen.

HTH
Bob

PS - YAY for my 1000th post ! lol
 

Watch MrExcel Video

Forum statistics

Threads
1,118,083
Messages
5,570,118
Members
412,305
Latest member
Mozz
Top