Hi,
thanks for your assistance, I can now hide the sheet2, however, I have
created an hyperlink to open the sheet2 but in the web page I cannot view
anything at all if it's hidded.

The results is same if I were to hide in excel and publish in web page.
is there anyway I could still hide the sheet2 in webpage but and to open
when I click on the hyperlink?
e.g.
sheet1 = hyperlink to open sheet2
sheet2 = (hidden in web page) but once click on sheet1, it's blank nothing
appear.

Appreciate your assistance.


"topola" wrote:

Open Visual Basic Editor from EXCEL:
Tools Macro Visual Basic Editor
alternatively
ALT + F11.

In VISUAL BASIC EDITOR:
With the proper VBAProject i.e. your workbook e.g. Book2:
Insert Module
In Module Copy and Paste the provided code for the two macro procedures
(beging with "Sub ...", ending "End Sub" each).

Back in Excel (you can use Alt + Tab) you should already have two
macros available.
Tool Macro Macros (Alt + F8). Here you can RUN them.

When you hide proper sheets (run macro Hide_My_Worksheet) try exporting
the workbook to the web again.

Report us where you are...
--
Topola, http://vba.blog.onet.pl