Excel vba application screenupdating does not work Chat with dirty locals 100 free
Find(What:=Checklist_Date, After:=Active Cell, Look In:=xl Values, Look At:= _ xl Part, Search Order:=xl By Rows, Search Direction:=xl Next, Match Case:=False _ , Search Format:=False). Paste Special Paste:=xl Paste Values, Operation:=xl None, Skip Blanks _ :=False, Transpose:=True Worksheets("Database").Hi friends, I have a huge code for worksheet change events.The tasks line up in rows and you simply select yes, no or N/a, for that task for the day on the calendar. Excel doesn't remember that the screenupdating was set to false by a previous macro and even if it did the code you have turns it back on anyway. Activate With Worksheets("Add Tasks to Month's Calendars") . You can save the checklist and it copies the information to a data sheet in a separate tab. You should be able to solve this by setting screenupdating to false on your first line, the modification is shown below.
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 Personally I would just set the screenupdating property to false without checking it, once the VBA has finished running the screen will update as normal.