Home ยป Application.ScreenUpdating property
Learn
Excel Macro: List All Files From zip File
This Excel macro can list all files from zip file. Click here if you need to list all files in a folder […]
Learn
Excel Macro: Bulk Insert Pictures in Cells and Resize Them
Think you have a price list to send to your customers, you need to insert multiple product pictures in Excel, of course […]
ImageMso Office RibbonX Editor IRibbonUI.ActivateTab method LineFormat.Visible property FillFormat.UserPicture method Shapes.AddShape method IsEmpty function Shape.Name property Application.ScreenUpdating property Workbook.Path property For Each...Next statement With statement If...Then...Else statement Dir function
Learn
Excel Macro: Highlight the Active Row and Column
The VBA code examples show ways to highlight the active cell or the rows and columns that contain the active cell. Get the VBA code now!
Range.Column property Range.CurrentRegion property Range.Select method Range.EntireColumn property Range.EntireRow property IsEmpty function Worksheet.SelectionChange event Worksheet.BeforeDoubleClick event Application.ScreenUpdating property Interior.ColorIndex property Range.Interior property Range.Address property On Error statement
Learn
Excel Macro: Create a Table of Contents of Sheets
This Excel macro not only creates a table of contents at the beginning of the workbook, but it also adds hyperlinks. Get this VBA code now!
Learn
Excel Macro: Create a New Workbook for Each Sheet
Sometimes you may need to create a new workbook for each sheet, it seems very boring to do it manually, this macro can help you. Get it now!
Learn
Excel Macro: Group Worksheets by Color
If you assign colors to your Worksheet tabs, you may want to sort or group Worksheets based on their tab colors, this macro can help you.
Learn
Excel Macro: Sort Worksheets by Name
If you want to sort multiple worksheets by name, it seems very boring to do it manually. In this situations, you can use this simple macro.
Docs
Application.ScreenUpdating property
True if screen updating is turned on. Read/write Boolean. Syntax expression.ScreenUpdating expression A variable that represents an Application object. Remarks Turn screen […]