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....

Hi Corey,
Add...

Application.ScreenUpdating = False


to the beginning of your code.

Ken Johnson

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

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

Sorry Corey,

I meant ScreenUpdating instead of DisplayAlerts ...

Carim

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

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

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).