View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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






.