Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel html workbook
I have a 40-sheet Excel workbook that is published as html for intranet
access. I want the users to see sheet2 whenever they click on the hyperlink (rather than the worksheet that was displayed with the workbook was last saved). Excel doesn't seem to recognize ranges when the workbook is saved as html, so using //oncall-docs.htm#sheet2 doesn't seem to work. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel html workbook
I have had success with this routine. Just replace "Menu" with the name of
the sheet you want to open with. Private Sub Workbook_BeforeClose(Cancel As Boolean) If Sheets("Menu").Visible = False Then Sheets("Menu").Visible = True ActiveSheet.Visible = False ElseIf Sheets("Menu").Visible = True Then End If End Sub -- Pops Jackson "ISA" wrote: I have a 40-sheet Excel workbook that is published as html for intranet access. I want the users to see sheet2 whenever they click on the hyperlink (rather than the worksheet that was displayed with the workbook was last saved). Excel doesn't seem to recognize ranges when the workbook is saved as html, so using //oncall-docs.htm#sheet2 doesn't seem to work. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
Save Workbook as HTML | Excel Discussion (Misc queries) | |||
specify each sheet name when saving workbook as html | Excel Discussion (Misc queries) | |||
hyperlink tospecific sheet of html workbook | Excel Worksheet Functions | |||
Publishing Workbook or Worksheet (HTML) | Excel Programming |