Hide the spreadsheet
No on the correction, i is adjusted by the FOR loop
adding to j was some dummy work - yes, it is just to cause a delay. It was
for demonstration purposes only.
--
Regards,
Tom Ogilvy
"Mike Fogleman" wrote in message
m...
Tom, that would be
i = i + 1
This creates a kind of 'Wait' command adjusting the length of time with
the number.
Mike F
"Tom Ogilvy" wrote in message
...
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
|