How to NOT show other screens flashing by when macro runs
 

i have a macro that navigates to other worksheets and back and forth carrying out some designated macros and steps.

Is it possible to say when viewing SHEET1, that the macro does it's work, WITHOUT actually being able to see the screens flashing by in the progress?


Corey....

How to NOT show other screens flashing by when macro runs
 

Hi Corey,
Add...

Application.ScreenUpdating = False


to the beginning of your code.

Ken Johnson

How to NOT show other screens flashing by when macro runs
 

Hi Corey,

Go ahead early in your VBA code with :

Application.DisplayAlerts = False

and don't forget at the end of your code to reverse the instruction
with :

Application.DisplayAlerts = True


HTH

Cheers
Carim

How to NOT show other screens flashing by when macro runs
 

Insert:
Application.ScreenUpdating = False
at the beginning of the macro and
Application.ScreenUpdating = True
at the end.
Usually it solves the problem.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=571119

How to NOT show other screens flashing by when macro runs
 

Sorry Corey,

I meant ScreenUpdating instead of DisplayAlerts ...

Carim

How to NOT show other screens flashing by when macro runs
 

Carim wrote:
Sorry Corey,

I meant ScreenUpdating instead of DisplayAlerts ...

Carim

Plus no need to reset back to TRUE. This happens automatically after
code has finished.
However, it does have to be TRUE if you are wanting to throw up an
InputBox.

Ken Johnson

How to NOT show other screens flashing by when macro runs
 

thanks guys.

I still get the popup calendar, but now if i click the X it closes and i
still get the macro to run to completion.

Corey....
"raypayette" wrote
in message ...

Insert:
Application.ScreenUpdating = False
at the beginning of the macro and
Application.ScreenUpdating = True
at the end.
Usually it solves the problem.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile:
http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=571119

How to NOT show other screens flashing by when macro runs
 

raypayette wrote:

Application.ScreenUpdating = True
at the end.

This is not necessary. It automatically resets to True after the macros
finish.

Don <www.donwiss.com (e-mail link at home page bottom).