Thread: Screen Flicker
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Screen Flicker

Try

Sub openaccess()
Application.ScreenUpdating = False
''do your code stuff here
Application.ScreenUpdating = True
End Sub

Gord Dibben XL2002

On Sat, 1 Nov 2003 18:26:05 -0500, "JonWayn" wrote:

How do I prevent the screen flickers I get when I open an Access database
programatically from Excel?

Thanx