running macro at the background

  • Thread starter Thread starter christine
  • Start date Start date
C

christine

Can someone help me plzzzzzzz.
I have recorded some macros that whenever i run them i
have to run them through an excel sheet. I would like to
know how to run the macros without running them from the
excel sheet. I only want the process to run at background
without user viewing the actual process.
thanks in advance
 
at the beginning:

Application.ScreenUpdating = False


at the end

application.ScreenUpdating = True

will hide the activities of the macro, but beyond that, macros don't really
run in the background.
 
Back
Top