VBA equivalent to "echo off"
How can I stop an Excel macro from displaying the intermediate steps on the
screen except until after it has completed. I guess I'm looking for the VBA equivalence to "echo off" for DOS. Your help will be much appreciated. Brian |
VBA equivalent to "echo off"
Sub Whatever()
Application.ScreenUpdating = False Your code here Application.ScreenUpdating = True End Sub Biff "Brian" wrote in message ... How can I stop an Excel macro from displaying the intermediate steps on the screen except until after it has completed. I guess I'm looking for the VBA equivalence to "echo off" for DOS. Your help will be much appreciated. Brian |
All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com