Hide Horizontal Scrollbar

[Joy Cooper]

Hello

I am creating a dashboard in Excel for multi user access and would like to know if there's a way of hiding the horizontal toolbar without using the Tools> Options function which only applies the settings on an individual's PC as opposed to hiding the scrollbar within that workbook.

Many thanks

[Aussiebear]

Try the following

[vba]
Private Sub HideHoriScrollBar()
With ActiveWindow
.DisplayHorizontalScrollBar = False
End With
End Sub
[/vba]

[Joy Cooper]

Thanks for the response. Unfortunately, the code provided didn't work and generated the following error:

Run-time error '438':

Object doesn't support his property or method

Not sure if it's because I'm using Excel 2003.

Any other help/suggestions gratefully received.

[GTO]

Greetings Joy,

There is just an errant space in .DisplayHorizontalScrollBar

In regards to your question - I do not believe you can rid the scrollbar(s) at the PC per se, or even with a given workbook, as the scrollbars are part of the window object. Thus, let's say you have a workbook open, and hide the scrollbar. If you add a new window, the scrollbar will exists in second window.

Mark

[Joy Cooper]

Super, thank you.

[Aussiebear]

Sorry about that..... typoitis