tabs in webpage
Hi,
I've hidden my sheet tabs via the tools - options - view, but when published in web view or saved as web page they appear, how can I hide? (Hidden pages must be available with hyperlink on sheet 1) Thank you. |
tabs in webpage
You can make the sheets veryhidden.
http://www.j-walk.com/ss/excel/usertips/tip036.htm Try this simple macro, and modify to suite your needs: Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets If (sh.Name) < "Password" Then If sh.Visible = True Then sh.Visible = xlSheetVeryHidden End If End If Next sh Regards, Ryan--- -- RyGuy "Hansn" wrote: Hi, I've hidden my sheet tabs via the tools - options - view, but when published in web view or saved as web page they appear, how can I hide? (Hidden pages must be available with hyperlink on sheet 1) Thank you. |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com