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.
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.