Forum

Notifications
Clear all

Hide sheet tabs in Excel online workbook

4 Posts
2 Users
0 Reactions
371 Views
(@baxbax)
Posts: 125
Estimable Member
Topic starter
 

Hi,

I have a workbook that has several worksheets. On the first sheet I have hyperlinks to the other sheets. I want to hide the sheet tabs. I can do this under settings in the desktop version of Excel but how can I do this with an online version?

I have created an html file version using the instructions in your post ( https://www.myonlinetraininghub.com/interactive-excel-web-app-dashboard). This works great and I can hide the download options but can't hide the tabs. Is there a way to insert anything in the html/java script to do this?

Thanks

 

Bax

 
Posted : 13/11/2018 2:46 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Bax,

If you hide a sheet that has a hyperlink to it, the hyperlink won't work.  So there isn't a way to do this with an embedded workbook either I'm afraid.

Regards

Phil

 
Posted : 13/11/2018 8:02 pm
(@baxbax)
Posts: 125
Estimable Member
Topic starter
 

Hi Phil,

I am not looking to hide the sheets I just don't want to display the tabs. In the desktop version you can turn the display off by going to File --> Options --> Advanced. The Show Sheet Tabs is under the Display options for this workbook.

Thanks

 

Bax

 
Posted : 14/11/2018 3:30 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Bax,

Sorry you can't do that with an embedded workbook either.

Regards

Phil

 
Posted : 14/11/2018 6:55 am
Share: