VBA Turn Scroll Bars On or Off
In this Article
You can toggle scrollbars On or Off using a macro:
Turn On Scrollbars
|
1 2 3 4 5 6 |
Sub TurnOnScroll() With ActiveWindow .DisplayHorizontalScrollBar = True .DisplayVerticalScrollBar = True End With End Sub |
Turn Off Scrollbar
|
1 2 3 4 5 6 |
Sub TurnOffScroll() With ActiveWindow .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False End With End Sub |
VBA 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!
Did you find this VBA tutorial useful? Then share it with your friends and colleagues:
[yuzo]
