Hide the spreadsheet
Application.Visible = False
or
Sub ABC()
Application.WindowState = xlMinimized
For i = 1 To 10000000
j = j + 1
Next
Application.WindowState = xlNormal
End Sub
if you are doing a lot of selecting just try using
Application.ScreenUpdating = False
Sub MyExistingSub()
Application.Screenupdating = False
' current commands
Application.Screenupdating = True
End Sub
--
Regards,
Tom Ogilvy
"David" wrote in message
ps.com...
I was wondering if it would be possible to hide the normal excel window
while a macro was running. Thanks
- David
|