Emailed workbook not showing worksheet tabs

[jman0707]

I have an Excel 2007 workbook that's been used for 5 months or so now. Recently, people I email it to say they can only see one worksheet in the workbook when they open it, and are unable to switch to any other worksheets in the workbook (they can't even see the tabs). They are in the "normal" view, and I have no idea what else could be wrong. Did I mess something up with the protection? Any other ideas to check??? Thanks so much!

[Big Chris]

Jman0707,

If it's visible when you send it and there's no auto_open macros that run procedures to hide the tabs on arrival I suspect that it's most likely an ID 10 T error....where the recipient can't see the tab because their horizontal scroll bar is set wide and the tab has shifted left off the page. This sometime occurs too when the tab name is very long.

It's going right back to basics, but I've had many queries with similarly basic and amazing answers....not their fault they don't know.

[jman0707]

OK, so how would I fix this? Can they just use the horizontal scroll bar to find the tabs? Or is there a setting for them to change so they can see the tabs. It does show the one tab that was showing when the document was last saved, but none others. There are about 6 tabs, none of which has a name longer than 8 characters or so. Let me know on this, thanks Big Chris!

[shg]

Try the four little scroll buttons at the lower-left of the window.

Also, you can drag the divider between the tab area and the horizontal scroll bar to expose more of one or the other.

[jman0707]

Yeah it looks like the divider was the problem. Thanks for your help!