Re: Application.screenupdating = false?? What's going on?
- From: "Jonathan West" <jwest@xxxxxxxx>
- Date: Fri, 11 Jul 2008 15:58:25 +0100
Application.ScreenUpdating isn't as efficient as it ought to be at actually
freezing the screen. It has always been like that and I don't expect
Microsoft to fix it any time soon.
You could instead minimize the active window for the duration so that the
black lines don't appear.
--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
"JuanManuel" <JuanManuel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C38FAE9-DA38-4F9C-85B6-8ABC3FEF7A61@xxxxxxxxxxxxxxxx
Hi,
I have the following code:
Private Sub RadBtnCI_Click()
Dim otable As Table
For Each otable In ActiveDocument.Sections(4).Range.Tables
Application.ScreenUpdating = False
Call HideTableRows_fromRadioButtons(otable)
Application.ScreenUpdating = True
Next
RadBtnCI.Select
End Sub
The "HideTableRows_fromRadioButtons" subroutine unhides plenty of rows in
many tables and calls other subroutines. It takes 15-20 seconds to
complete.
During this time, despite of the Application.ScreenUpdating = False, the
left side of the screen gets filled up with black horizontal lines.
Application.ScreenUpdating = False DOES prevent the screen from showing
how
each table expands and collapses gradually, but I'd like to know whether
it's
possible to get rid of these annoying black lines that might confuse the
user
and led him to think that the computer is going to crash.
The black lines do dissappear when the subroutine is complete, but 20
seconds of black lines filling up the screen is annoying, unprofessional
and
makes you think the program is crashing.
Any help is appreciated,
Thank you
.
- Follow-Ups:
- Re: Application.screenupdating = false?? What's going on?
- From: fumei via OfficeKB.com
- Re: Application.screenupdating = false?? What's going on?
- References:
- Application.screenupdating = false?? What's going on?
- From: JuanManuel
- Application.screenupdating = false?? What's going on?
- Prev by Date: Re: Progress bar that tracks actual progress??
- Next by Date: RE: Insert sentence only if text field is not null
- Previous by thread: Application.screenupdating = false?? What's going on?
- Next by thread: Re: Application.screenupdating = false?? What's going on?
- Index(es):