Quote Originally Posted by mmf View Post
DaveExcel
I am just using very simple code to open and close workbooks with activate select copy and pasting commands in between
Activate & Select are causing your problems here. As far as I know using either of them will switch screenupdating back to true, (as both Activate, and 'Select' are visual functions, so therefore HAVE to update the screen).

You need to recode your copy & paste routines to not use the select or activate functions.