+ Reply to Thread
Results 1 to 5 of 5

Problem deleting worksheet

  1. #1
    Short-Fused User
    Join Date
    06-15-2015
    Location
    Dunfermline
    MS-Off Ver
    2007
    Posts
    5

    Problem deleting worksheet

    I am currently working on an Excel Workbook and wish to delete one of the worksheets from it. I have tried right clicking on the worksheet tab but the delete button is greyed out. I have tried selecting the worksheet, going to the home tab at the top of the screen and selecting delete which allows my to delete cells, columns and rows but again the delete worksheet button is greyed out. Any help with this problem very much appreciated. I am using Windows 7 and Microsoft Office version 2007

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Problem deleting worksheet

    Is the workbook protected for sharing? This has the effect of greying out the delete option.
    Martin

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Problem deleting worksheet

    Is the sheet, or the workbook, protected at all?
    If posting code please use code tags, see here.

  4. #4
    Short-Fused User
    Join Date
    06-15-2015
    Location
    Dunfermline
    MS-Off Ver
    2007
    Posts
    5

    Re: Problem deleting worksheet

    Hi mrice, I don't believe the workbook is protected. One of the worksheets is protected but I tried removing the protection and doing the delete. It never made any difference. Sorry, forgot to mention that in my original post

  5. #5
    Short-Fused User
    Join Date
    06-15-2015
    Location
    Dunfermline
    MS-Off Ver
    2007
    Posts
    5

    Re: Problem deleting worksheet

    Norie, please see my response to mrice who asked the same question. Thanks for the response

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem deleting worksheet name as variable from a list
    By zondervanamo in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-06-2013, 12:23 PM
  2. #Ref! problem when deleting a worksheet
    By NickExcel in forum Excel General
    Replies: 3
    Last Post: 08-18-2011, 10:58 AM
  3. Problem Deleting Row
    By walkingthecow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-28-2008, 05:15 PM
  4. Problem in deleting one row.
    By sethi85 in forum Excel General
    Replies: 1
    Last Post: 11-29-2007, 10:33 AM
  5. [SOLVED] deleting values in a worksheet without deleting the formulas
    By patti in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2005, 05:05 PM

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