Results 1 to 29 of 29

Thread: Application.ScreenUpdating = false does not work

Threaded View

  1. #11
    New Member
    Join Date
    Dec 2009
    Posts
    1

    Re: Application.ScreenUpdating = false does not work

    Application.screenupdating = False was not stopping the screen update when it was call straight in an event.

    In my case, when adding Application.screenupdating = False in my Workbook_BeforeSave code, it did not do it's job.
    When I moved the code I wanted to run before save to it's own module, then called the module from Workbook_BeforeSave, it worked like a charm...(events disabled in module, so additional sheet level events did not trigger)

    Hoping this will help someone else out - drove me crazy for a while!!!
    Last edited by G-Ma0801; Dec 15th, 2009 at 08:57 AM. Reason: additional info

Posting Permissions

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



Click Here to Expand Forum to Full Width