PDA

View Full Version : Solved: Switching off background actions.



WebGuy
05-15-2006, 12:20 AM
Hi!
Since i am very new to VB my knowlege is very limited. I have however managed to use vb to script a few helpful programs(mainly sort& select routines).
My question is regarding one of my sort & select routines. My script adds, subtracts, multiplies and summarizes thousands of values in 3 different sheets. This means that there is a lot of jumping between sheets. I an trying to find a way to do all the sheet jumping and calculating in the background while only showing the main sheet. Does anyone know if this is possible.
//Henry VBRookie

johnske
05-15-2006, 12:24 AM
Put Application.ScreenUpdating = False at the head of your code and Application.ScreenUpdating = True at the end of it :)

Oh, I just noticed ... and welcome to VBAX

WebGuy
05-15-2006, 12:39 AM
Thank you very much !
That worked perfectyly, now i dont have to watch thousands of numbers flashing by !

johnske
05-15-2006, 01:01 AM
Not a prob. :)