View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default 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