Description
Arranges the windows on the screen.
Syntax
object.Arrange(arrangeStyle, activeWorkbook, syncHorizontal, syncVertical)
object
Required. The Windows object.
arrangeStyle
Optional. Arrange windows in this style. Can have one of the following values:
Value
Meaning
xlTiled
Windows are tiled (the default value, used if arrangeStyle is omitted).
xlCascade
Windows are cascaded.
xlHorizontal
Windows are arranged horizontally.
xlVertical
Windows are arranged vertically.
xlIcons
Arranges the icons (not available on the Apple Macintosh).
activeWorkbook
Optional. If True, arranges only the visible windows of the active workbook, instead of all the windows in Microsoft Excel. If False or omitted, arranges all the windows.
syncHorizontal
Optional. Ignored if activeWorkbook is False or omitted. If True, the windows of the active workbook are synchronized when scrolling horizontally. If False or omitted, the windows are not synchronized.
syncVertical
Optional. Ignored if activeWorkbook is False or omitted. If True, the windows of the active workbook are synchronized when scrolling vertically. If False or omitted, the windows are not synchronized.
Example
This example tiles all the windows in the application.
Application.Windows.Arrange arrangeStyle:=xlTiled