Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Mar 2005
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ScreenUpdating in Excel (Office97 + )

    Hi all,

    Can you enlight me on this little enigma:

    My scenario is this:

    Application.ScreenUpdating = false
    ... work on cells, rows, cols AND controls in a sheet.
    Application.ScreenUpdating = true

    Is seems that turning ScreenUpdating on/off only has to do with cells only or maybe even only contents of cells. What I want to do i to completely turn off visual interaction from a sheet while updating it and then next turn it back on to see my result. While I work on it I must hide/show rows/cols and interact with a lot of controls on the sheet (lists, buttons, images etc.). Setting them invisible dos not seem to do me any good.

    So I'm in a situation where I want a: Application.SeriousScreenUpdating = { True / False }


    Any ideas?


    Regards,
    Michael.

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

    Re: ScreenUpdating in Excel (Office97 + )

    Have you tried hiding the entire worksheet while you're modifying it? (there must be at least one worksheet that remains visible)

  3. #3
    Lounger
    Join Date
    Mar 2005
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ScreenUpdating in Excel (Office97 + )

    Now I have... it seems to be *almost* possible - some controls (date ctrls) complains about this approch though. Perhaps making a huge shield of some sort - a textbox or something...

    Anyway thanx' to you Hans!

    regards,
    Michael

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ScreenUpdating in Excel (Office97 + )

    How about looping through a Flash presentation... or an "interesting" <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20> movie? You might never get the user back to the worksheet. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Alan

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: ScreenUpdating in Excel (Office97 + )

    Hi Michael,

    Another approach would be to leave the worksheet visible, but temporarily hide its rows and/or columns.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  6. #6
    Lounger
    Join Date
    Mar 2005
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ScreenUpdating in Excel (Office97 + )

    Or use Appel Mac. or .... *S*

  7. #7
    New Lounger
    Join Date
    Sep 2004
    Location
    York, Virginia, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ScreenUpdating in Excel (Office97 + )

    In my programs I also shut off calculation to speedup the application.
    I use

    Application.Calculation = xlManual
    Application.ScreenUpdating = False

    at the start and use

    Application.Calculation = xlAutomatic
    Application.ScreenUpdating = True

    at the end.

    Hope this helps.

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

    Re: ScreenUpdating in Excel (Office97 + )

    I'd try two things:

    1. Instead of opening the worksheet directly in the GUI, try creating a hidden instance of Excel and working thru that instance. When done, you could then make the worksheet visible. Of course, you will have to make sure that the operations you are performing can be accomplished with a hidden worksheet. Might require significant reprogramming to achieve this goal.

    2. You could use the Windows API to lock the window.

Posting Permissions

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