View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default 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!