Application.screenupdating fail

DaveExcel
I sused that one but still the same, I still see how the applciation just flash from one screen to another.

Dominicb, What does sendkey means?
I am just using very simple code to open and close workbooks with activate select copy and pasting commands in between

Cheers

Originally Posted by mmf

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.