ExcelBanter - supress display during execution of an excel macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - supress display during execution of an excel macro (https://www.excelbanter.com/excel-programming/398208-supress-display-during-execution-excel-macro.html)

Stu Littleton

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?

Trevor Shuttleworth

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?

Stu Littleton

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!

Trevor Shuttleworth

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!

All times are GMT +1. The time now is 12:35 PM.