Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

  1. #1
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,365
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    I am getting the error from the title of the thread when I try to change a worksheet name.

    This worksheet name doesn't already exist in the workbook and I don't have any other files currently open.

    I'm not entirely sure what is causing this, but I do need the sheet to be the name I am trying to change to.

    Any suggestions?


    Thanks

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    What name are you trying to give it?
    Microsoft MVP - Excel

  3. #3
    MrExcel MVP
    Join Date
    Dec 2008
    Location
    Phoenix, Arizona
    Posts
    6,154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    What is the name you are trying to change to?

  4. #4
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,365
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    I need to name it 'London East'

  5. #5
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    Are you sure you don't have a hidden worksheet with that name (Format|Sheet|Unhide)? If not check the workbook's references in the Visual Basic Editor.
    Microsoft MVP - Excel

  6. #6
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,365
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    Definitely no hidden sheets but not sure how to check the VBE references....

  7. #7
    MrExcel MVP
    Join Date
    Dec 2008
    Location
    Phoenix, Arizona
    Posts
    6,154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    Peter probably has a brighter idea, I was expecting a reserved name.

    I think the easiest/first thing would be to go to Format|Sheet|Unhide and see if you may have inadvertantly created it before and hid it.

  8. #8
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    Quote Originally Posted by mikeymay View Post
    Definitely no hidden sheets but not sure how to check the VBE references....
    In the Visual Basic Editor select your workbook in the Project window and choose Tools|References.
    Microsoft MVP - Excel

  9. #9
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,365
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    In the Visual Basic Editor select your workbook in the Project window and choose Tools|References
    This shows a list of available reference some tick, the majority not. Do I need to look for a reference with the name that I am trying to use?

  10. #10
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: 'Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook refernced by Visual Basic'

    You only need to look at the ones that are checked.
    Microsoft MVP - Excel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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