Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rename Worksheet

    I added a worksheet and tried to rename it to "Breakdown". Whe I hit enter, the name changed to ".xls]Breakdown" and the name change was accepted. Now when I try to rename it it gives the message to the effect of I have not entered a valid name.

    Strange.....

    Thanks, Simon

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rename Worksheet

    What method are you using to change the name. Are you enetering a new name on the worksheet tab, or are you using VBA ?

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename Worksheet

    Entering the name onto the worksheet tab.

    Simon

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rename Worksheet

    Does it reject all names, or just a specific name. Try changing the new name slighly and see if that helps

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename Worksheet

    It rejects all names. The file is on the network so I tried it on another machine - same. I have tried a single letter, double letter. The only way out is to hit escape. I have left it with the default "sheet 3" for now .

    Simon

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rename Worksheet

    Could you create a copy of the file (minus any data of course) and if the problem persists post to the forum, and somebody might find a cause. Seems strange, I assume there is no form of protection involved.

    Andrew

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename Worksheet

    I will create a copy tomorrow, strip out all the other worksheets and if it still has the problem I will post it.

    Thanks, Simon

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename Worksheet

    Try inserting a new sheet, copy everything from the problem sheet, past it to the new sheet, then try deleting the problem sheet.
    Legare Coleman

Posting Permissions

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