Get the Usable Height and Width : ActiveWindow « Application « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Application
  3. ActiveWindow

Get the Usable Height and Width

 

Sub GetActiveWindowUsableHeightWidth()
    MsgBox ActiveWindow.UsableHeight
    MsgBox ActiveWindow.UsableWidth
End Sub








Related examples in the same category

1.Toggle Headings
2.Toggle Gridlines
3.Splitting a Window 70 percent of the way down the window:
4.To remove the split from the window, set the Split property to False:
5.scrolls the active window up two screens
6.To display the Document Map for a window at the Document Map's previous width percentage (of the document's window), set the DocumentMap property to True:
7.Positioning and Sizing a Window: set its Left and Top properties
8.To size a window, set its Height and Width properties:
9.Opening a New Window
10.Changing the View
11.Zooms the active window to 150 percent:
12.Working with Panes