VBA Turn Scroll Bars On or Off


You can toggle scrollbars On or Off using a macro:

Turn On Scrollbars

Sub TurnOnScroll()
    With ActiveWindow
        .DisplayHorizontalScrollBar = True
        .DisplayVerticalScrollBar = True
    End With
End Sub

Turn Off Scrollbar

Sub TurnOffScroll()
    With ActiveWindow
        .DisplayHorizontalScrollBar = False
        .DisplayVerticalScrollBar = False
    End With
End Sub