Seet tabs not showing

I am using excel 2007 but saving all projects as xls rather than xlsx for reasons too long to on. Problem that just occurred is that there are no sheet tabs at bottom of screen. I checked "display options for this workbook" and "show sheet tabs" item is checked. Any help much much appreciated.

There is definitely more than one sheet. The visible sheet has several values that are generated with calculations on another sheet based on input values from the visible sheet. I made some changes to check and get proper results, so other sheets definitely exist. I saved the xls file as xlsx and have the same problem. Very frustrating.

Did you close out of all open workbooks when you tried the "Display options for this workbook"?

This might be a duplicate reply-I started another then and had to go elsewhere and didn't see my reply on my return.. Problem of no sheet tabs is fixed-not sure how. I gave a copy to a friend who called microsoft (he pays for some service) to update his office file. My file then showed the sheet tabs and he emailed me a copy. But, I didn't get the tabs to show until about the third time I opened the file. The surprising thing is that, then, the other sheets, in my computer, also started showing tabs. Did something in his file modify my excel innards?

Even though we didn't fix this, I learned a several other things from you. Thank you very much.

I'm not sure how this site works. I posted a reply to you, but it is showing on CODFleet's reply. In case you didn't get it-here is a copy of my reply:

Re: Seet tabs not showing
This might be a duplicate reply-I started another then and had to go elsewhere and didn't see my reply on my return.. Problem of no sheet tabs is fixed-not sure how. I gave a copy to a friend who called microsoft (he pays for some service) to update his office file. My file then showed the sheet tabs and he emailed me a copy. But, I didn't get the tabs to show until about the third time I opened the file. The surprising thing is that, then, the other sheets, in my computer, also started showing tabs. Did something in his file modify my excel innards?

Even though we didn't fix this, I learned a several other things from you. Thank you very much

Replying to post number 8. Thanks will do next time. Do you have any knowledge about what happened, why the tabs returned the wy they did?

I thought my problem was over, but loss of tabs is happening again. I entered the vba code you gave me. I am weak on vba in excel. How do I activate it?

Thanks much. You have taught me a lot about vba in Excel I use it in Access all the time-much easier. That website you named is good for someone like me.

I did get the tabs to show in a strange way. I click View, then Arrange All. I don't change anything, click OK and they appear. Strange. Thanks again for all the time you have give me.