Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing sheet tab (Excel 00)

    I have a problem with my workbook, My sheet called DiJis is missing the tab and I have check the options setting and the sheet tabs show is click on I am wondering if Ihave a corrupt work book

    ??

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing sheet tab (Excel 00)

    Can you post a copy of your workbook (zipped if necessary)? You can clear all cells, and delete all VBA modules (if any).

  3. #3
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Missing sheet tab (Excel 00)

    thanks for the reply i have attached the workbook

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Missing sheet tab (Excel 00)

    Put the mouse on the left margin of the screen and drag the "split" to the right enough to see the left side of the spreadsheet. Click in the left side of the spreadsheet and try Window|Remove split.

  5. #5
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Missing sheet tab (Excel 00)

    thanks it worked, any idea how that happened?

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Missing sheet tab (Excel 00)

    It's not possible to tell you how that happened, but I suspect someone split the screen at one time and you were sent that version.

Posting Permissions

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