running macro at the background
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.
--
Regards,
Tom Ogilvy
christine wrote in message
...
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
|