|
-
Dec 15th, 2009, 08:45 AM
#11
New Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|