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.