Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Location
    Yorba Linda, California, Uruguay
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Restoring Settings in Excel (Excel 2000)

    Can anyone help?? the tabs for the worksheet Disappeared as well as all data contained in them. I thought that my computer had a virus but I ran the virus scan a found it to be clean. Is there any way I can restore it ???

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Restoring Settings in Excel (Excel 2000)

    Try tools - options - View tab

    near the bottom right is the "Sheet tab" box checked? Check it.

    Steve

  3. #3
    New Lounger
    Join Date
    Aug 2003
    Location
    Yorba Linda, California, Uruguay
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restoring Settings in Excel (Excel 2000)

    I did put a check mark on it but I still do not get the tabs back

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Restoring Settings in Excel (Excel 2000)

    Window size might be set wrong, try MAXIMIZING the window for the sheet. Upper -right corner, center button It is LOWER group of the 3, the upper group is EXCEL's Min, max/restore, close buttons. You want the set for the sheet

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restoring Settings in Excel (Excel 2000)

    IF sdckapr's tip doesn't work, you can try setting up a standard module in the VB Editor. Choose Tools|Macro|Visual Basic Editor - or Alt+F11 - and then Insert|Module. Copy and paste the following code into the window that opens up. Place your cursor in the middle of the block of text and then press F5. <pre>Sub UnhideSheets()
    Dim p As Integer
    For p = 1 To ActiveWorkbook.Worksheets.Count
    Sheets(p).Visible = True
    Next p
    End Sub</pre>

    HTH
    Gre

Posting Permissions

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