Can macro display a diff't screen while it runs until it stops?
You can hide Excel...
Sub stuff()
On Error GoTo ErrorHandler
Application.Visible = False
'Your Code here
ErrorHandler:
Application.Visible = True
End Sub
You should have the error handler with this (similar to above). It would be
a bad thing if it ran into a problem and just never came back...
--
HTH...
Jim Thomlinson
"KT" wrote:
Is there coding I can add to a macro that will change the display to a
different screen (such as the desktop or something) once the macro starts
running and then, when it's finished, go back to the worksheet it started on?
I know there's Worksheet.Activate but I'm looking for something a little
different.
Thanks!
|