Thread: tabs in webpage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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.