Excel Macro VBA Tip 19 - Speed up Macros in Excel by Turning Off Screen Updating
15.5 هزار بار بازدید -
15 سال پیش
-
Visit
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.
This is a great tip for how to speed up the operation of your Macros in Excel. You will learn how to prevent the screen from updating when you run the macro. This means that you won't see anything happen on the screen until the macro has finished running. The tutorial will show you how to turn screen updating off for the macro and then how to turn it back on once the macro has finished running.
For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!
This is a great tip for how to speed up the operation of your Macros in Excel. You will learn how to prevent the screen from updating when you run the macro. This means that you won't see anything happen on the screen until the macro has finished running. The tutorial will show you how to turn screen updating off for the macro and then how to turn it back on once the macro has finished running.
For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!
15 سال پیش
در تاریخ 1388/08/14 منتشر شده
است.
15,505
بـار بازدید شده