VBA Turn Scroll Bars On or Off
In this Article
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