Results 1 to 4 of 4

Thread: Losing My Tabs

  1. #1
    Join Date
    Sep 2005

    Unanswered: Losing My Tabs

    I know it's careless but a friend has managed to do just that! We have checked the Options and the check box is ticked, we have checked to see if some nice person hs added a macro - nothing, we have opened a new workbook and the tabs are there, same for other existing workbooks.

    Anyone any bright ideas? It's Excel XP and I suspect it's just had a moment and will need to re-create the workbook.

  2. #2
    Join Date
    Oct 2003
    Perhaps the Split Screen is being used, and scrolled all the way to the left.

    Or if you use the horizontal scroll bar, and drag it all the way to the left, then the tabs disappear. In this case, select the left side of the horizontal scroll bar and drag it to the right.
    Last edited by shades; 09-23-05 at 13:41.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Sep 2004
    Hi Chris,
    I had a similar problem with a report i inherited last year. It turned out that someone had used a 'veryhidden' function as an upon open function. Took ages to find out what it was. Have a look in the VBA window and see if that is the case (unless the last answer solved the problem). Unfortunately i cant remember how i fixed it probably something simple like removing the code but should be fairly easy to find the answer on the web.

    Hope this has helped in some small way.


  4. #4
    Join Date
    Oct 2005
    I am confused. What is missing? The sheets? Or the sheet tabs?

    To bring back the sheets, ALT+F11 > Select the sheet inthe explorer window under Microsoft Excel Objects > select xlSheetVisible in the Visible property.

    To bring back the tabs, Tools menu > Options > View page > check Sheet tabs.

    I hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts