How to: Hide the Action of a Macro

J

Jasper

I have severall macro's doing a lot of work and taking considerable time to
do so. As a result the user sees a lot of things I'd rather have they didn't
see.

My Question: "How can I show the Sheet "Index" while the macro is running?"

Thanks in advance!
 
H

Harald Staff

Sub Test()
Dim i As Long, j As Long
Sheets("Index").Select
Application.ScreenUpdating = False
For j = 1 To 200
For i = 1 To ActiveWorkbook.Sheets.Count
Sheets(i).Activate
Next
Next
Application.ScreenUpdating = True
End Sub


HTH. Best wishes Harald
 
Top