how to run recorded macro without showing processing excel sheets
You posted your code - it doesn't run any other macros - why do you think it
might?
--
Regards,
Tom Ogilvy
wrote in message
...
Ken, i think you are right. I have posted the codes. what
do i have to delete from those codes?
-----Original Message-----
Is there a chance that your macro runs another macro
that sets
screenupdating back to true somewhere in the middle of
the procedure? The
usual guidance is to reset screenupdating back to true
at the end of the
procedure, but usually I prefer not to do that because
it happens
automatically when processes all complete, and often I
will later call a
procedure from another procedure and the second
procedure will set
screenupdating to true if I have previously followed the
convention of
setting screenupdating back to true and as it turns out,
the could be
premature.
Ken
"Tom Ogilvy" wrote in message
...
It works for everybody else.
from excel vba help on screenupdating:
Turn screen updating off to speed up your macro code.
You won't be able to
see what the macro is doing, but it will run faster.
sounds an awful lot like what you are asking, No?
--
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. And it
display
all the excel sheets. About 10 separate sheets.I
would
like to
know how to run the macros without showing all of the
processing excel sheets. Without user viewing the
actual
processes.
Thanks in advance
Please this macro does not work:
at the beginning:
Application.ScreenUpdating = False
at the end
application.ScreenUpdating = True
.
|