Application.screenupdating fail

**mmf** · 08-28-2008, 08:24 AM

HI
I have a workbook which has a code with the following structure:

Please Login or Register  to view this content.

Even using the application screenupdating I can see how the subname1 goes and open go to the sheets and close files to copy and paste.

Any idea why this is happening?. I used in the past the property to copy and paste data from one sheet to another and worked fine, so I am not sure why this time is not working, the difference this time is that I am using external data from other workbooks

Best regards

**davesexcel** · 08-28-2008, 08:31 AM

I don't know if this will help, but maybe placing the screen updating code in the module that calls the macro IE:

Please Login or Register  to view this content.

**dominicb** · 08-28-2008, 08:59 AM

Good afternoon mmf

Does your code use SendKeys?
If so, then the Application.ScreenUpdating construct is ineffective against this command.

HTH

DominicB

**mmf** · 08-28-2008, 09:28 AM

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

**Tom Schreiner** · 08-28-2008, 09:35 AM

Sometimes this construct works where App.ScreenUpdating fails.

Please Login or Register  to view this content.

**mmf** · 09-10-2008, 07:20 PM

thnaks for the suggestion, I did what you wrote, and works for one of the sub, however for another ones I still having the blinks,
best regards

**davesexcel** · 09-11-2008, 05:12 AM

Originally Posted by mmf

thnaks for the suggestion, I did what you wrote, and works for one of the sub, however for another ones I still having the blinks,
best regards

If you have selects in your code the blinks may be inevitable.
Whats the code look like?

**Phil_V** · 09-11-2008, 11:43 AM

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.