Tried, still cannot hide sheet 2 in the web page :(
thanks anyway.

"topola" wrote:

Hi,
I don't have experience with exporting Excel to web. I expect however
that it should behave in a similiar way. Forgive me if I am wrong.

I would try using macro procedures instead of hyperlinks.
I assume we are hiding/unhiding sheet1.

This would select cell C3 in sheet1:
Sub MyCell1()
Hide_My_Worksheet
Cells(3,3).Select
End Sub

This would go to the range called MyRange:
Sub MyRange1()
Hide_My_Worksheet
Application.Goto Reference:="MyRange"
End Sub

To hide sheet1 when you leave it:
Right click on Sheet1 tab. Select ViewCode. In this module copy/paste
this command:

Private Sub Worksheet_Deactivate()
Hide_My_Worksheet
End Sub

Check how it works for you and let me know,
Regards,
Tomek