This means that the Excel screen can look like it has "gone crazy" while the macro is running.One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running. 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").By the way, I am having the same problem where I set it to False and it doesn't go false.Many people write their own macros to manipulate the information in a workbook.Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.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".
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.
You can save the checklist and it copies the information to a data sheet in a separate tab. Also I think that the problem is that the second peice of code that runs when you open the worksheet does not turn screenupdating to false so you will see all the movements you described.
Remember to set the Screen Updating property back to True when your macro ends.
This example demonstrates how turning off screen updating can make your code run faster.