Excel html workbook

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 1
Macro for all Excel Workbooks to print to PDF 2
Hyperlink from HTML to a specific Excel workshhet 1
Hard code the workbook name in macro 2
Collate data from multiple workbooks into one worksheet 0
Split file, saving each tab/worksheet to a new workbook, w/tab asworkbook name? 4
[VBA] How to convert an Excel woorkbook completely from Excel 2003to Excel 2007? 3
specify each sheet name when saving workbook as html 1

Top