| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turning off screen update while macro runs | Excel Programming | |||
| Keep display steady while macro runs | Excel Programming | |||
| Display a message whilst a macro runs | Excel Programming | |||
| Display a message whilst a macro runs | Excel Programming | |||
| Flickering of the Screen when the Macro runs. | Excel Programming | |||
Linear Mode
