+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Delete sheet and Unhide greyed out

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    detroit
    MS-Off Ver
    Excel 2007
    Posts
    14

    Delete sheet and Unhide greyed out

    Hello friends,

    I have been having this issue for a while now. I cannot right click on a sheet and delete or unhide it. I read through the forum and checked that the worksheet is not protected and sharing is turned off.
    I would also like to add that this issue happens when I open a new excel file as well.
    I tried to run excel in safe mode and it gave me the option to delete but unhide was still greyed out.
    If I get the option of delete in safe mode, is it some macro running in the background?
    I have attached some screenshots for your review .excel help.docx

    I need to use these options regularly.

    Please help

    Thank you
    Last edited by abhinavn; 04-12-2012 at 03:49 PM. Reason: Solved

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    Re: Delete sheet and Unhide greyed out

    Can you upload a copy of one of the workbooks in which you're experiencing this?

    As for 'Unhide...' not being available, are you sure there are hidden sheets within the workbook? (If they were hidden using 'xlSheetVeryHidden' in VBA, then you won't be able to unhide them using the context menu of the worksheet tab.)

    Just for giggles, you could run this macro in the VB Editor window:
    Please Login or Register  to view this content.
    The Ply commandbar object is the context menu (right-click menu) for worksheet tabs. This will reset it to default. (Again, if there are no hidden sheets the 'Unhide..' option will still be grey.)

  3. #3
    Registered User
    Join Date
    11-11-2009
    Location
    detroit
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Delete sheet and Unhide greyed out

    Thank you Paul, it worked..
    I had tried the same code earlier but for some reason it did not work

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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