Results 1 to 5 of 5
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Any suggestions for the reason for sheet tabs and scrollbars suddenly disappearing from a workbook?
    Things I checked: There is no code in the workbook to control sheet tabs and scrollbars. Nor in the Excel options were the sheet tabs and scrollbars turned off.

    A stop/start of excel and reopened it solved the problem - but I'm wondering why.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does installing SP2 solve this problem too? (Cf. Post 783840)

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    [quote name='HansV' post='783871' date='09-Jul-2009 16:40']Does installing SP2 solve this problem too? (Cf. Post 783840)[/quote]
    hmm must check this out.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Go to your Windows Logo
    Open Excel Options
    Choose the Advanced Option on the left
    Go to your Display settings as shown in the graphic

    I did however load SP2 today. Maybe it's a bug that SP2 corrects. If you have checked the Options then I am baffled.

    Maybe:

    1. This problem sometimes happens after you unhook the workbook window from the Excel window (by using the Restore Window button in the trio of buttons on the title bar), and then inadvertently move the window beneath the status bar. This may also occur if your computer's screen resolution is higher than that of the person who last saved the workbook.

    2. If you widen the horizontal scroll bar at the bottom of a worksheet, you may unintentionally hide some or all of the sheet tabs.

    3. Was this a workbook in Excel 2003 where all the sheet tabs were purposelyhidden.

    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    We had very similar experience where tabs appeared to be missing (mysteriously 'stolen' by the workstation bug).
    For some reason the worksheet window had been 'restored', moved down the application window, and then 'stretched' back to fill the application window. So it looked quite normal apart from the tabs and scroll bars missing. The bit that gave it away was the close worksheet X being off screen to the right.
    Very crafty and mysterious.

Posting Permissions

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