Forum Discussion
Scroll Bars
I have inserted a number of scroll bars on a worksheet. These roughly run across columns C and D and are on rows 4,6,8 etc. Is there a way to unhide/hide all the scroll bars at once? Hiding or groupi...
Many ways lead to a solution ... that is the good and at the same time complex in Excel :).
You can also toggle on and off with VBA code:
In the code module of the corresponding task sheet (right click on the table name in the sheet register, "Show code"):
Private Sub Worksheet_Activate()
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
End Sub
Private Sub Worksheet_Deactivate()
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
End Sub
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.