+ Reply to Thread
Results 1 to 3 of 3

tab disappears when left clicked or right clicked

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    Illinois
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    86

    tab disappears when left clicked or right clicked

    I am working with a fairly large file size spreadsheet (~2mb) and for some reason, when I click on one particular tab, the tabs disappears as well as the row numbers on the left side as well. However, when I use the shortcut to cycle through tabs (CTRL + PGUP or PGDOWN), all the other tabs work fine, but when I get to this certain tab, the tabs and row numbers disappear. I tried all the google tricks I could find such as maximizing the windows, making sure tabs aren't set to disappear in Excel etc, but this has me stooped b/c it only does it on ONE worksheet within the whole book. All the other tabs work fine until you get to this certain one, then they all disappear, but like I said, once you cycle pass it, the other tabs and even its tab become visible again. (The other tabs don't behave this way when you right click or left click though). Any suggetions on what is causing this and how to fix?

    HP RodNuclear

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: tab disappears when left clicked or right clicked

    Sounds like there might be VBA coding on that sheet. Can you right click on that tab and "View Code" and see if there is any code on that worksheet?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    11-04-2010
    Location
    Illinois
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    86

    Re: tab disappears when left clicked or right clicked

    I can right click it (but when I do, the tab disappears, yet the right click menu still comes up somehow) and no there isn't any code for that sheet. I think Excel is glitched b/c there is A LOT of data on this one sheet and it somehow triggered a weird software response and I am obviously clueless on how to fix it. Any other suggestions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1