Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA - Scrrenupdating....does .View take precedence (Env: O2000 sr-1 on eit

    Hi,

    Would anyone know if it is so, that if I change the .View setting in word this overrules any
    application.screenupdating=false that may precede it ??

    (it definitely looks so, eg. I swap from "PageView" to "HeaderFooterView" and back, my screen is constantly
    updated with a lot of flickering, though Application.Screenupdating=False)

    Any ideas - thanks,
    ;o)) henrik
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA - Scrrenupdating....does .View take precedence (Env: O2000 sr-1 on

    In general, setting ScreenUpdating = False in Word and Excel, or Echo = False in Access, works only partly; it doesn't seem to prevent flickering. I have noticed this in many situations.

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA - Scrrenupdating....does .View take precedence (Env: O2000 sr-1 on

    Screenupdating = False gets overridden by Word in lots of circumstances.
    Short of using the Windows API to lock the window, there's no geberal solution.

    Often one can re-organize/re-code the code to reduce screen flicker.
    In Word, the best way is to use the Range object instead of the Selection object.
    Once the Range object is used, one needs to re-organize the code to reduce flicker.

    If the code was originally written for (or designed AS IF), say, Word 97, screen flicker will be exacerbared in Word 2000 and Word 2002, unless the code is redesigned to take into account the difference between MDI on Word 97 and SDI in Word 2000/2002.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: VBA - Scrrenupdating....does .View take precedence (Env: O2000 sr-1 on

    Is it possible to minimize the flickering window(s) while the process runs?

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA - Scrrenupdating....does .View take precedence (Env: O2000 sr-1 on

    To some extend - if I following a view change add a .screenupdating=false, then it works (most the time) until the next change in the "View" setting.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  6. #6
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA - Scrrenupdating....does .View take precedence (Env: O2000 sr-1 on

    Howard, appreciate your comment, thanks.

    What API would you use ?
    - wouldn't it block for other dialogs from the same application, or would they run in separate threads ?


    ;o) Henrik
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA - Scrrenupdating....does .View take precedence (Env: O2000 sr-1 on

    I would not use the API.
    Best to convert from Selection to Range object, etc.

    You'll end up with much faster and easier to maintain code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •