Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel doc saved as an HTML file - can't unhide worksheet
Hi,
I am in the process of creating a dashboard for our group that is Excel based, but is saved as an HMTL file for ease of everyone viewing. In this early stage of development - I created just 3 tabs of reports and 1 tab of calculations. All the data is external, so I needed a calculations tab that made final calculations on certain pieces of data. However - when I output the results as an HTML file - I did not want the calculations tab to show. So - I hid the tab just before saving the file as HTML. While I was tweaking the initial version I hid and unhid the tab several times with no problem - but the Excel window was still open. I since closed the file and Excel and now a week later I wanted to make a few more tweaks to the file. upon reopening the dashboard file - I notices all my graphs were showing all 0's. I then went to unhide the Calculations tab so I could investigate what happened and I am not able to unhide the tab any more! The unhide options in various menus are just grayed out! I even tried this command in the immediate window but I just get an error Run time error "9". Subscript out of range. Worksheets("Calculations").Visible = True So - that sinking feeling in my gut is telling me that somehow this tab is now gone and my work from last week is gone. But I was hoping that I could find a miracle from someone here. I am using Office/Excel 2007. The filename I am working with is "TS_Dashboard.HTML". -- Glenn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
Running Macros from Excel Saved as html file | Excel Programming | |||
Excel file not opening when saved with Extention .html | Excel Worksheet Functions | |||
can I hyperlink to a worksheet tab in workbook saved as html? | Excel Discussion (Misc queries) | |||
Picture disappears when saved as html file | Excel Discussion (Misc queries) |