Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Aug 2003
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rename sheet grayed out (Excel 2000)

    One of my users created some spread sheets but when she right clicks to rename a sheet, "rename" is grayed out. There are also items on the drop down menus that are also grayed out. There is no protection on the document and it is not set up to be shared. Any ideas how to get those commands back?

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

    Re: Rename sheet grayed out (Excel 2000)

    If you don't get an answer shortly, could you possibly attach a copy of the workbook (edited if necessary to remove any private information)?
    Legare Coleman

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename sheet grayed out (Excel 2000)

    Renaming sheets requires that the workbook not be protected. You said you checked that the worksheet isn't protected but did you check the workbook? If the workbook is protected you can't add/remove/rename sheets. The worksheet and the workbook can have different passwords.

    Deb <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

  4. #4
    2 Star Lounger
    Join Date
    Aug 2003
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename sheet grayed out (Excel 2000)

    I when to Tools, Protection and didn't see anything under sheet or book. How would I know if it is protected at either level? Thanks

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename sheet grayed out (Excel 2000)

    When you say you "don't see anything under protection" do you mean it's empty? Under Tools/Protection there are three items:

    protect worksheet
    protect workbook
    protect and share workbook

    If either of these are protected then it'd say "unprotect" instead of "protect" since you need to select one of these and provide a password to unprotect it. (Try this yourself on a new workbook.)

    You can also rename a sheet from the Format/Sheets menu on the top menu bar. This of course will also be grayed out if the workbook is protected (the sub-menu under Format/Sheets will be grayed, not the Format menu itself).

    Is there any code (VBA/macros) in this workbook? If yes then the code could be the one protecting the workbook. Also if there are any add-ins running, one of them could of protected it.

    Deb <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

  6. #6
    2 Star Lounger
    Join Date
    Aug 2003
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename sheet grayed out (Excel 2000)

    Deb--It was protected at the workbook level. Thanks for solving our mystery! Now if the user could only remember what she used for the password.....

  7. #7
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rename sheet grayed out (Excel 2000)

    Navigator Utilities will unlock the password for you. Go to the Sheet Navigator and click "Unprotect WB". You'll find that Navigator Utilities has heaps of other useful stuff for moving around sheets, links names etc. Go to http://www.robbo.com.au for download.

    regards
    Mark

Posting Permissions

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