How to: Hide the Action of a Macro

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!

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

"Jasper" <[email protected]> skrev i melding
news:[email protected]...
> 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!