I'm using Excel 2007 and all of a sudden, I can't see my worksheet tabs either. The problem occurs with any workbook that I open, not just one.
I went to Excel Options, Advanced and then under "Display options for the workbook" the "Show sheet tabs" box is checked. I tried unchecking it...