Scroll Bars

%3CLINGO-SUB%20id%3D%22lingo-sub-1856505%22%20slang%3D%22en-US%22%3EScroll%20Bars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856505%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20inserted%20a%20number%20of%20scroll%20bars%20on%20a%20worksheet.%20These%20roughly%20run%20across%20columns%20C%20and%20D%20and%20are%20on%20rows%204%2C6%2C8%20etc.%20Is%20there%20a%20way%20to%20unhide%2Fhide%20all%20the%20scroll%20bars%20at%20once%3F%20Hiding%20or%20grouping%20the%20columns%20doesn't%20hide%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1856505%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1856706%22%20slang%3D%22de-DE%22%3ESubject%3A%20Scroll%20Bars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856706%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F858562%22%20target%3D%22_blank%22%3E%40ColinMac2180%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHide%20or%20display%20scroll%20bars%20in%20a%20workbook%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhide-or-display-scroll-bars-in-a-workbook-2101e630-fa9b-4d22-90e0-b110278bafa7%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhide-or-display-scroll-bars-in-a-workbook-2101e630-fa9b-4d22-90e0-b110278bafa7%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1856708%22%20slang%3D%22en-US%22%3EBetreff%3A%20Scroll%20Bars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856708%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3Bbut%20I'm%20not%20referring%20to%20the%20horizontal%20and%20vertical%20scroll%20bars.%26nbsp%3B%20Instead%2C%20I'm%20talking%20about%20scroll%20bar%20form%20controls%20that%20are%20on%20the%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 grouping the columns doesn't hide them.

 

Thanks

3 Replies
Highlighted

@ColinMac2180 

 

Hide or display scroll bars in a workbook

https://support.microsoft.com/en-us/office/hide-or-display-scroll-bars-in-a-workbook-2101e630-fa9b-4...

 

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.

Highlighted

Thanks for this @Nikolino but I'm not referring to the horizontal and vertical scroll bars.  Instead, I'm talking about scroll bar form controls that are on the worksheet.

Highlighted

@ColinMac2180 

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.