PDA

View Full Version : Hide Horizontal Scrollbar



Joy Cooper
08-31-2010, 03:57 AM
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
08-31-2010, 05:01 AM
Try the following


Private Sub HideHoriScrollBar()
With ActiveWindow
.DisplayHorizontalScrollBar = False
End With
End Sub

Joy Cooper
09-01-2010, 01:36 AM
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
09-01-2010, 04:08 AM
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
09-01-2010, 04:35 AM
Super, thank you.

Aussiebear
09-01-2010, 02:42 PM
Sorry about that..... typoitis