How to: Hide the Action of a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving a bunch of data 1
How to record a macro within a macro 9
Get Name of Sheet to use in Macro 11
moving rows to another sheet 3
vba macro that allows insertion of symbols at cursor 0
Need Adaptable Macro 9
How to Create a Macro to Import External Data 0
Macro running slow 7

Back
Top