Can macro display a diff't screen while it runs until it stops?
 

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!

Can macro display a diff't screen while it runs until it stops?
 

one way

Application.WindowState = xlMinimized

do your thing
Application.WindowState = xlNormal



--
Greetings from New Zealand
Bill K

"KT" wrote in message
...
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!

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!