+ Reply to Thread
Results 1 to 6 of 6

Greyed Out: Delete Sheet and Rename Sheet when right clicking on sheet name????

  1. #1
    Registered User
    Join Date
    01-24-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2003
    Posts
    3

    Angry Greyed Out: Delete Sheet and Rename Sheet when right clicking on sheet name????

    Problem:
    On every single excel file I own...
    When right clicking on sheet name -> both delete and rename are greyed out.
    Under edit menu -> Cut, copy, and paste special are greyed out.

    Possible Solutions I have tried:
    Worksheet is not protected.
    Workbook is not protected.
    I tried copying the sheets to a new book and it still doesn't work.

    Solution, but not really:
    While in Excel in Safe mode everything works. This made me believe that it was a macro. I removed all add ins and macros and the problem still exists.

    Oh yes another thing. After I completed all my work in a workbook and saved it in two different locations. The work was missing next time I opened it.

    Please Help!
    Last edited by aoliver2; 01-24-2012 at 03:11 PM. Reason: spelling

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Grayed Out: Delete Sheet and Rename Sheet when right clicking on sheet name????

    What was the last thing you were doing before it broke?

  3. #3
    Registered User
    Join Date
    01-24-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Grayed Out: Delete Sheet and Rename Sheet when right clicking on sheet name????

    Couldn't tell you. Haven't used my computer in over a week, been busy out in the field.

  4. #4
    Registered User
    Join Date
    01-24-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Grayed Out: Delete Sheet and Rename Sheet when right clicking on sheet name????

    OK so I have uninstalled microsoft office and reinstalled and now I get the following errors:
    Compile Error in hidden module: Main
    There is an add-in built by our company but it is protected so I can't access it.
    Any suggestions???

  5. #5
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Greyed Out: Delete Sheet and Rename Sheet when right clicking on sheet name????

    Sounds like you need admin rights.

  6. #6
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Greyed Out: Delete Sheet and Rename Sheet when right clicking on sheet name????

    If you uninstall the add-in, does the error go away? If so, you will need to talk to your IT people to get the error fixed. I suspect your original problem was an error in your .xlb toolbar file.
    Good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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