Hide Scroll Bar in Sheet

[smitpau]

Hi,

Hopefully this is possible.

I'd like to hide the horizontal scroll bar in a specific worksheet.

The code below does it generally for all tabs, would appreciate some help tailoring it to only apply for the "Results" worksheet

Code - For All Sheets:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
DisplayHorizontalScrollBar = False
End Sub

Thanks

 

[Fluff]

How about using

Private Sub Worksheet_Activate()
   ActiveWindow.DisplayHorizontalScrollBar = False
End Sub

Private Sub Worksheet_Deactivate()
   ActiveWindow.DisplayHorizontalScrollBar = True
End Sub

 

[smitpau]

Thanks Fluff yes that works well, (nice minimal/effective code).

 

[Fluff]

You're welcome & thanks for the feedback.