Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
tabs in excel flagged out in webpage NOT | Excel Worksheet Functions | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
editable webpage or pop-up | Excel Discussion (Misc queries) | |||
webpage tabs | Excel Programming |