Make sure that the scroll bars and status bar are hidden and that the formula bar is displayed: : Application Windows « Application « VBA / Excel / Access / Word






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

Make sure that the scroll bars and status bar are hidden and that the formula bar is displayed:

 
Sub scroll()
    With Application
        .DisplayScrollBars = False
        .DisplayStatusBar = False
        .DisplayFormulaBar = True
    End With
End Sub








Related examples in the same category

1.Transform all windows into icons
2.Zoom a form
3.Zooming a Window and Setting Display Options
4.Set the window position and size
5.Center application
6.To change the values of the WindowState, Width, and Height properties of the Excel application window, you must explicitly reference the Application object