Vba application screenupdating false does not work
The idea is to use the first line near the beginning of your macro, and then use the second line near the end.Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.also with the screenupdating turned off and on, the users will not notice the wkbook being opened at all.just my two cents suggestion glad you like Mr Spreadsheet's solution, but i like the open workbook solution better as it is more flexible.I’ve posted several examples of manipulating pivot tables with VBA, for example, Dynamic Chart using Pivot Table and VBA and Update Regular Chart when Pivot Table Updates.These examples included specific procedures, and the emphasis was on the results of the manipulation.
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.
Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately.