VBA Turn Scroll Bars On or Off
Written by
Reviewed by
Last updated on April 5, 2019
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 SubTurn Off Scrollbar
Sub TurnOffScroll()
With ActiveWindow
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With
End SubVBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
