Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default supress display during execution of an excel macro

What is the vba code to turn off the display during the execution of an excel
2007 macro?
  #2   Report Post  
Posted to microsoft.public.excel.programming
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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default supress display during execution of an excel macro



"Stu Littleton" wrote:

What is the vba code to turn off the display during the execution of an excel
2007 macro?

Thank you Trevor, that works beautifully!
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,089
Default supress display during execution of an excel macro

You're welcome. Thanks for the feedback.


"Stu Littleton" wrote in message
...


"Stu Littleton" wrote:

What is the vba code to turn off the display during the execution of an
excel
2007 macro?

Thank you Trevor, that works beautifully!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to supress display of FALSE in a cell akkrug New Users to Excel 6 June 20th 08 12:59 PM
Excel crashing on macro execution Keith74 Excel Programming 1 June 5th 07 04:52 PM
Supress display of multiple steps in Macro MicroMain Excel Programming 2 January 18th 06 04:19 AM
Macro execution from Excel IF function Bryan Morris Excel Programming 6 October 5th 04 05:39 AM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"