View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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