Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Row Headers Disappear (Excel 2002)

    Hi,
    One of my colleage's row headers disappear occasionally... it seems to happen after she's run a macro. To fix it, she closes Excel and re-opens it... then the rows reappear. Is there another way to fix this problem?
    Thanks!
    Lana

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Row Headers Disappear (Excel 2002)

    Select "Tools > Options > View"
    Place a tick in the "Row & column headers" box in the "Windows Option" section.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Row Headers Disappear (Excel 2002)

    I looked there and it was already checked... so I unchecked it, then re-checked it, and it still didn't work.

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Row Headers Disappear (Excel 2002)

    Is it possible to post the macro here to see if we can work out why it causes the headers to disappear.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Row Headers Disappear (Excel 2002)

    It only happens on her computer, not on anyone elses... and it happens after she runs several different macros... so I can't pin point a macro. None of my macros hide the row headers, so I'm not sure why they'd be hidden... and why they can't be un-hidden.

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

    Re: Row Headers Disappear (Excel 2002)

    Your colleague could try Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  7. #7
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Row Headers Disappear (Excel 2002)

    We've just discovered that if she moves to a worksheet (within the same file) that has a pivot table in it, we can see the row headers, as they didn't disappear on these worksheets. Then she moves BACK to the other worksheets and the row headers have all re-appeared. No one else seems to have this problem of disappearing row headers... she's the only one, and it happens after she runs a macro... any macro.
    Thanks,
    Lana

Posting Permissions

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