Here’s why: First, no matter what the help files may say, or what you may have heard, Screen Updating does not always reset itself, including where User Forms and User Defined Functions are concerned.
Do not believe these claims — they are misinformed and dead wrong.
Whenever you set Screen Updating to False in your code, make certain to reset it to True.
I’ve seen the threads on this subject that recommend “fiddling with the code” or “calling the code in a subroutine”.
Unfortunately, I have to maintain hundreds of Excel applications each with thousands of lines of code and hundreds of users who are about to migrate to Office 2016, so rewriting is not an option. This solved my flicker problem, but I didn't like how the excel application disappeared completely then suddenly reappeared for the user.
Screen Updating = True End Sub Activating another worksheet and then again activating the required worksheet worked for me - I had a code where the screen updating failed, I activated another worksheet and then again the one I was working on, it updated the current screen. Screen Updating = False ''''''code''''''' Thisworkbook.worksheets(any otherworksheet in workbook).activate Thisworkbook.worksheets(current worksheet).activate application.
I'm pretty new to VBA, but I've found my way around by reading through these forums. Screen Updating not working and after researching online, I can't find an answer to my problem. Activate With Worksheets("Add Tasks to Month's Calendars") . Protect Password:="young C", _ Contents:=True, User Interface Only:=True End With End Sub I apologize for the misunderstanding in the question. Screen Updating doesn't stop all screen changes: do you see the data being pasted etc?
I was able to solve the issue to my liking by using a workaround this 'which window is on top' problem.
By leaving the main window alone, and forcing other workbooks to become not visible, letting the code run, then bringing them back to visible, it stopped flickering. I have been experimenting with this technique, and although it doesn’t stop the flickering completely, it improves the result in an important way: It restores visibility to the Status Bar message, which I update every few seconds to show the application’s progress.
Screenupdating isn't working and the user ends up seeing the flickering and jumping back and forth between the data sheet and the calendar view. Here's the Save checklist sub: Sub Save_Checklist() Dim Checklist_Date Dim Completed As Long Dim Left_to_Complete As Long Dim Database_Date As Range Dim Database_Row As Long Dim b Scr Update b Scr Update = Application. ", vb Yes No Cancel, "Reset the Calender") = vb Yes Then Checklist_Date = Worksheets("Daily Checklist"). You should be able to solve this by setting screenupdating to false on your first line, the modification is shown below. If I did store this value I would, though, declare it as a Boolean. If application.screenupdating = true and you set application.screenupdating = true again, you will see the screen flicker.
Screen Updating If b Scr Update = True Then Application. Unprotect Password:="young C" If Msg Box("This button will save this month's checklist data into the database. I would store the previous value of properties like Calculation though, and re-instate them, as in the OP. My client complained about this, so I had to change every statement to "if not (application.screenupdating = true) then application.screenupdating = true".
In 2003, 20 doing this enables the screen to temporarily update so you get a visualization of what the sheet now looks like however in 2013 it doesn't work...