Application.ScreenUpdating = False. A problem...

**Barking_Mad** · 11-14-2011, 05:58 AM

Hi,

We recently updated to Windows 7 at work and as a result one of my macros began to run really slowly, presumably because of the large grid size? Anyhow, this was the macro in question...

Please Login or Register  to view this content.

I solved the issue by adding:

Please Login or Register  to view this content.

at the start of the macro.

However what this does is to stop the Sheet2.Activate from working. This is important as the user needs to check the register to make sure the details are correct before printing. Can anyone think of a way round this?

**royUK** · 11-14-2011, 06:13 AM

It won't stop a sheet from being activated, but it will stop the screen refreshing until the code has finished. You must of course add Application.ScreenUpdating= True when the code has finished.

**Barking_Mad** · 11-14-2011, 07:07 AM

Originally Posted by royUK

It won't stop a sheet from being activated, but it will stop the screen refreshing until the code has finished. You must of course add Application.ScreenUpdating= True when the code has finished.

hi, sorry im not quite following you....I currently have:

Please Login or Register  to view this content.

However instead of the macro switching to Sheet2.Activate and displaying the print dialogue box, it stays on the same sheet the macro is run on and displays the print box. This means that the user cant chack what is about to be printed.

Am I making sense, or just misunderstanding you?!

**ianh** · 11-14-2011, 07:33 AM

I think you need to add the line Application.ScreenUpdating = True before the final part of your code. This re enables the scree to be updated so the suer can see the output

Please Login or Register  to view this content.

**Barking_Mad** · 11-14-2011, 07:59 AM

Hi,

I put it after the Sheet2.Activate and it worked fine - which was odd as I swear id tried that at least half a dozen times before! Maybe my lack of sleep is catching up with me!

Ta

**romperstomper** · 11-14-2011, 08:07 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save