#2 then the “ Visual Basic Editor” window will appear. #1 open your excel workbook and then click on “ Visual Basic” command under DEVELOPER Tab, or just press “ ALT+F11” shortcut. You can also use an Excel VBA Macro to achieve the result of hiding or unhiding horizontal and vertical scroll bars quickly. Hide and Unhide Horizontal and Vertical Scroll Bar with VBA Macro #4 if you want to unhide or show all scroll bar (horizontal bar and vertical bar), you just need to check those two check boxes in the Display options for this workbook section. #3 click Ok button, you will see that all scroll bar will disappear in your workbook. #2 select Advanced category, and scroll down to the Display options for this workbook section, then uncheck show horizontal scroll bar and show vertical scroll bar check boxes to hide all scroll bar in your workbook. #1 click File tab, and select Options menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |