how do I turn the screen off during macro execution
I don't have 2007 but I think this will work.
Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True
HTH
Regards,
Howard
"redondo" wrote in message
...
There a way to turn off the screen when macros are executing so you can't
see
the macro running and then turn the screen on to display the results when
the
macro has completed. I can't figure out how to do this in excel 2007.
|