Thread: supress display during execution of an excel macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
  
Posts: 1,089
Default supress display during execution of an excel macro
Application. ScreenUpdating = False
' your code
Application. ScreenUpdating = True

Regards

Trevor


"Stu Littleton" wrote in message
...
What is the vba code to turn off the display during the execution of an
excel
2007 macro?


Reply With QuoteReply With Quote