VB ScreenUpdate = False

[HotNumbers2001]

How Can I make the Macro Run without showing all the steps on screen while it is profoerming the Macro.

I used the following code in the begining of the Macro but doesn't seem to work. Does Anyone have any ideas?


Application.ScreenUpdating = False

 

[Nimrod]

Your problem may be real ineffcient code ... if you post your code it maybe that it can be simplified to run in a second or two and without the "flashes" .I've seen Code that has the "selects" taken out of it change from taking 20+ seconds to under 1 second !

 

[Smitty]

Listen to Nimrod (and NateO & others) who will tell you to avoid "Selects" like the plague! It really does make a difference! And follow Nimrod's other response and post your code. It'll get cleaned up in a jiffy!

Smitty

 

[izzy]

How Can I make the Macro Run without showing all the steps on screen while it is profoerming the Macro.

I used the following code in the begining of the Macro but doesn't seem to work. Does Anyone have any ideas?


Application.ScreenUpdating = False

Sorry about sticking my nose in again but it's working fine for me HotNumbery. I'm using Excel-2000


BUT...
30 seconds or so of staring at a button with an hourglass over it would likely drive my boss nuts too.

SO...
A progress indicator would be perfect, TY for the offer PennySaver. I could use something like that while I convert all my time consuming formulas over to VB which will be a fun learning experience.

...Mess with this again and I'll melt down your hard drive if you don't give me a raise". Smitty

LMAO