While developing some Excel VBA based tools in Excel, you might find this useful when you want to disable or enable horizontal or vertical scrolling in excel automatically.
It is very easy to disable the Horizontal or Vertical Scroll bar using the VBA code. They are self-explanatory by the way. So here you go:

• To enable/visible Horizontal and Vertical Scroll Bar
• To disable/invisible Horizontal and Vertical Scroll Bar

VBA code to Show Horizontal or Vertical Scroll bar

Sub ScrollOn()
With ActiveWindow
.DisplayHorizontalScrollBar=True
.DisplayVerticalScrollBar=True
.DisplayWorkbookTabs=True
End With

VBA code to hide Horizontal or Vertical Scroll bar

Sub ScrollOn()
With ActiveWindow
.DisplayHorizontalScrollBar=False
.DisplayVerticalScrollBar=False
.DisplayWorkbookTabs=False
End With

How to Show/Hide Scroll Bars without VBA Code

It is also possible to show or hide Scroll bars of Excel in Excel Options as well. I have written this below article to show how to achieve this manually :

Hide/Display Horizontal/Vertical Bar in an Excel Workbook