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 Excel 2010, you could control whether or not the screen updates while a macro is running by setting Application. In Excel 2013, screen updating cannot be controlled in this way.
Screen updating is especially important for long-running macros (e.g.
I've created a Daily Checklist application in excel that gives a month view in the Daily Checklist. You should just see it changing sheets and workbooks [email protected] unfortunately the macro recorder will rarely show 'good' ways to do things, but it is useful for finding out certain properties or when dealing with things like pivot tables / data connections.
The tasks line up in rows and you simply select yes, no or N/a, for that task for the day on the calendar. Using 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.
Calculation = xl Calculation Automatic 'to reset all formula calcs before deleting source Main Wrk Bk.
Paste Special Paste:=xl Paste Values, _ Operation:=xl None, Skip Blanks:=False, Transpose:=False Application.
Excel will default save it to your add-ins directory.I'm running a couple of tests to make sure it's working properly. The biggest problem I'm running into is that when I run the code (despite having Screen Updating set to False), it visibly opens the library file while it runs the macro. interactive macros, long calculations) to let the user know that the macro is still running and that Excel has not crashed.Here are some links to people who have also noticed this problem:
(code below) I have module that calls forms and subs from a main sub to carry out a number of tasks - within each of the subs (except the main) I turn off screen updating in the beginning and turn it on at the end (example below).