Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Hide Or Display Scroll Bars In Workbook. It is an application level setting so will be applied to all workbooks open within the application. To control scroll bars visibility in the GridDesktop use the IsVerticalScrollBarVisible and IsHorizontalScrollBarVisible properties.
Go to Display Options for this Workbook Section Step 5. Hiding Scroll Bars To hide scrollbars set the properties that control visibility to false. Click on Excel Options Step 3.
Under Windows Settings scroll down and then click Ease of Access Display.
Data_dir FiledirnameFiledirnameFiledirname__FILE__ data Instantiating a Workbook object by excel file path workbook RjbimportcomasposecellsWorkbooknewdata_dir Book1xls Hiding the vertical scroll bar of the Excel file workbookgetSettingssetVScrollBarVisiblefalse Hiding the horizontal scroll bar of the Excel file workbookgetSettingssetHScrollBarVisiblefalse Saving the modified Excel file in default that is Excel. Click Options and then click the Advanced category. You need to set these properties to False to hide them. Display all Scroll Bars ApplicationDisplayScrollBars True Hide all Scroll Bars.