Hide Macros in Excel while They Run

I often record short snippets of macros for ease of use and then record myself running all of them. What you can’t record is the screen flickering.

We often do not want see the macro as it runs, just the end result. Try this on your macro that runs all the other macros. (It also makes the macros run faster!)

Keyword for Help Menu: Application.ScreenUpdating

Sub RunAll()
‘
‘ RunAll Macro

‘Line Below with screenupdating set to false hides the macros as it runs

   Application.ScreenUpdating = False

‘Runs all the macros neccesary for this project
Application.Run “SampleForBlog.xls!FormatHeadings”
Application.Run “SampleForBlog.xls!FormatData”

‘Line Below with screenupdating set to true shows the end results

    Application.ScreenUpdating = True

End Sub

Thanks, Vicki, for asking the question!!!