G
Glenn Mulno
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".
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".