Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Can't delete worksheet

This is a discussion on Can't delete worksheet within the Excel Questions forums, part of the Question Forums category; I have a workbook with 3 worksheets. I am trying to delete 2 of the three but "Delete Sheet" is ...

  1. #1
    New Member
    Join Date
    May 2004
    Posts
    6

    Default Can't delete worksheet

    I have a workbook with 3 worksheets. I am trying to delete 2 of the three but "Delete Sheet" is grayed out in both the "Edit" menu and RtMouseClick menu. The sheets are not protected and the workbook is shared. Do I have to un-share the workbook in order to delete sheete? If so.. how do I do this?

  2. #2
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,399

    Default

    hello kilroy wuz heer, welcome to MrExcel.com board!!!

    it could be greyed out in lieu of workbook protection. sheet protection would not do that, you would still be able to delete individual sheets. but i'd check that first.
    Regards,
    Zack Barresse
    Excel & Access blog
    All Excel Functions
    Training
    (If you would like comments in any code, please say so.)

  3. #3
    Board Regular kidkl's Avatar
    Join Date
    Apr 2004
    Location
    Death Sea
    Posts
    93

    Default Re: Can't delete worksheet

    Just a thought. Try to "save as" the workbook and give a different name

  4. #4
    New Member
    Join Date
    May 2004
    Posts
    6

    Default Re: Can't delete worksheet

    ??English please for the intellectually challenged??

  5. #5
    New Member
    Join Date
    May 2004
    Posts
    6

    Default Re: Can't delete worksheet

    Just a thought. Try to "save as" the workbook and give a different name

    Been there, done that. No change- "Delete Sheet" still grayed (greyed?) out.

  6. #6
    New Member
    Join Date
    May 2004
    Posts
    6

    Default Re: Can't delete worksheet

    "it could be greyed out in lieu of workbook protection. sheet protection would not do that, you would still be able to delete individual sheets. but i'd check that first."

    Someone please translate firefytr's answer for me..

  7. #7
    Board Regular kidkl's Avatar
    Join Date
    Apr 2004
    Location
    Death Sea
    Posts
    93

    Default Re: Can't delete worksheet

    Just a guess..

    Maybe firefytr means that your wb is locked by a workbook protection and not a

    sheet protection..just a wild guess

  8. #8
    New Member
    Join Date
    May 2004
    Posts
    6

    Default

    So how do I unlock a workbook??

  9. #9
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,399

    Default

    Tools -> Protection -> Unprotect Workbook.

    if all entries under protection say 'Protect ...' then you're sheet/book is not protected, and that is probably not the problem.
    Regards,
    Zack Barresse
    Excel & Access blog
    All Excel Functions
    Training
    (If you would like comments in any code, please say so.)

  10. #10
    New Member
    Join Date
    May 2004
    Posts
    6

    Default

    Protect Sheet and Workbook are grayed out. Protect Workbook is available. If it helps.. I was mucking around with embedding this spreadsheet in a Visio page but is wasn't working so I deleted the link (I think) If I go to Share Workbook the only name that appears is me.

Page 1 of 2 12 LastLast

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
  •  


DMCA.com