Log In
Register
Home
New Member
September 7, 2020
Offline
Hello,
Could you please help me to hide the viewbar in my excel file 
I use Excel 2019 on Windows 10
Trusted Members
December 20, 2019
Offline
Not sure why you would want to in a worksheet but......
Sub scrollbars()
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
End Sub
July 16, 2010
Offline
Hi Christine,
Purfleet's instructions are for hiding the scroll bars in Excel for the desktop using VBA. I think based on your screenshot that you mean the viewer bar when embedding your file in a web page using the Excel Web App. If so, please see this tutorial. If you still have problems, then please share your code.
Mynda
October 5, 2010
Offline
Hi Christine,
Your image shows the workbook embedded in a web page so I'll need the address of that web page and the embed code you are using from OneDrive.
If you are just using the test HTML page I created here https://www.myonlinetraininghu.....-dashboard please supply that and the workbook embed code.
Regards
Phil
New Member
September 7, 2020
Offline
Hi Mynda,
Here is my code
<div id="myExcelDiv" style="width: 700px; height: 750px"></div>
<!-- * This code uses the Microsoft Office Excel Javascript object model to programmatically insert the
* Excel Web App into a div with id=myExcelDiv. The full API is documented at
* https://msdn.microsoft.com/fr-.....15812.aspx. There you can find out how to programmatically get
* values from your Excel file and how to use the rest of the object model. -->
<script type="text/javascript" src="https://onedrive.live.com/embed?resid=6575DB2DD5948D5%216247&authkey=%21APMLYYGNrBu4jLg&em=3&wdDivId=%22myExcelDiv%22&wdHideGridlines=1&wdHideHeaders=1&wdActiveCell=%22'Feuil1'!A1%22&wdAllowInteractivity=0"></script>
October 5, 2010
Offline
Hi Christine,
Did you try putting that code into the example HTML file I provided here
https://www.myonlinetraininghu.....-dashboard
because it worked right away to hide the viewer bar when I did.
To remove the horizontal and vertical scroll bars (see attached image) you will need to modify the embed code from OneDrive.
As it is the area of the sheet being embedded is very large. You've probably got Entire Workbook selected in the 'What to show' area - see attached image.
You should enter a range to display and then modify the width and height of the div in the embed code to accommodate this displayed range
id="myExcelDiv" style="width: 700px; height: 750px;"
The attached .txt file is actually a HTML file. Download it, change the file extension to htm, upload it to a website and it will load your workbook.
Regards
Phil
1 Guest(s)
