This content was proof-read by Grammarly. You can Try Grammary for FREE
Here’s a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel.
How to hide horizontal or vertical scroll bar using VBA Code in Excel ?
1. Open the Microsoft Visual Basic for Applications Window using the ALT + F11 keyboard shortcut key.
2. Select Insert -> Module and then paste the following code snippet.
Option Explicit Private Sub HideScrollBars() With ActiveWindow .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False End With End Sub
Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.