Step 2: Click Insert > Module, and paste the following macro in the Module Window: Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. The following VBA code also can help you show or hide the horizontal/vertical scroll bar. If you check them, the horizontal/vertical scroll bar will display, if you uncheck them, the horizontal/vertical scroll bar will hide.
![site contact bar at bottom before body code site contact bar at bottom before body code](https://accessbodywork.nl/wp-content/uploads/2020/03/IMG_2152.jpg)
And you will get the result that you want. Step 5: Checked or unchecked the Show Horizontal Scroll bar option and Show Vertical Scroll bar option according to your needs.Step 4: Scroll down to the Display options for this workbook section.Step 3: In the Excel Options dialog box, go to the Advanced category.Step 1: Click the File tab in Excel 2010 or higher version, or click the Microsoft Office Button button in Excel 2007.You have to configure Excel settings in Excel Options dialog box, if want to display or hide Horizontal/Vertical Scroll bar in Excel worksheets. Show/hide Horizontal/Vertical Scroll bar with Kutools for Excel Show or hide Horizontal/Vertical Scroll bar with VBA code
![site contact bar at bottom before body code site contact bar at bottom before body code](https://i.ebayimg.com/images/g/hXsAAOSwB8xfz9t5/s-l64.jpg)
Show or hide Horizontal/Vertical Scroll bar with Excel Options
![site contact bar at bottom before body code site contact bar at bottom before body code](https://images-na.ssl-images-amazon.com/images/I/51jmhqD-l3L._SX218_BO1,204,203,200_QL40_.jpg)
Here we will show you some tips to turn on or off the scroll bars in the Microsoft Excel worksheets. We can scroll through the active worksheet with horizontal scroll bar at the bottom and vertical scroll bar at the right side by default.
#Site contact bar at bottom before body code how to
How to show or hide Horizontal & Vertical scroll bar in Microsoft Excel?