ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Screen Flicker (https://www.excelbanter.com/excel-programming/281243-screen-flicker.html)

JonWayn

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

Thanx



Gord Dibben

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




All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com