I have the updating turned off - I was hoping there was a way to actually
make the screen go blank, such as when a screen saver kicks in. Maybe there
is a way to alter the screen saver parameters in VBA?

--
Bill @ UAMS


"Jim Thomlinson" wrote:

I assume that it would be good enough to keep the screen from flashing form
one sheet to the next as the macro executes? If so then just add something
like this to your code...

sub whatever()
Application.screenupdating = false
'your code here
Application.screenupdating = true
end sub
--
HTH...

Jim Thomlinson


"BillCPA" wrote:

I have an analysis macro I run every now and then that runs anywhere from 2-6
hours. If I run it on my desktop, I turn my monitor off while it runs. Is
there some way in VBA to turn off the screen on a laptop while the macro
executes?

--
Bill @ UAMS