Home > In Excel > {RESOLVED} Excel: Can't Delete Worksheet

{RESOLVED} Excel: Can't Delete Worksheet

Contents

Thanks. Have you tried doing it with VBA? When I go to tools>protection, the only option I have is to protect worksheet/workbook. It worked well for me. http://magicnewspaper.com/in-excel/solved-delete-option-gone-from-excel-2007-worksheet-tab-menu.html

Don't be discouraged when I reply to you with "I tried that already. You may have to enter a password to unprotect it. __________________ "Sorry, the number you have dialled is imaginary. The plus sign is there; I can edit and save sheets. Although, I can narrow down the month that this occurred I can't (easily) go back & start using that file since so many changes have been made since. http://www.excelforum.com/showthread.php?t=537594

Unable To Delete Sheet In Excel 2010

Or highlight the data you want to delete in the sheet and hit dlete on the keyboard. Register Help Remember Me? If it helps.. Click Tools -> Protection -> Unprotect Workbook.

sheet protection would not do that, you would still be able to delete individual sheets. asanchez192, welcome to the forum Perhaps you missed reading post # 10? edit flag offensive delete link more add a comment Question Tools Follow 1 follower subscribe to rss feed Stats Asked: 2014-08-11 21:31:08 +0100 Seen: 1,567 times Last updated: Aug 13 '14 How To Delete A Worksheet In Excel 2010 My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages

how do I do this? Delete Sheet Greyed Out Excel 2013 Advertisement jimi Thread Starter Joined: Jun 14, 2000 Messages: 3,941 i have a set of excel worksheets (a workbook ?) with lots of years worth of data that needs to be Last edited by 1695814; 07-02-2013 at 12:13 PM.. 1695814 View Public Profile Find all posts by 1695814 #2 07-01-2013, 11:18 PM ActSciMan Member CAS Join Date: Nov 2010 Not sure when it occurred, whether immediately after the new installed or soon after.

Why can't I delete my Excel worksheet? Unable To Delete Sheet In Excel 2016 Off-Topic Tags How-tos Drivers Ask a Question Computing.NetForumsOffice SoftwareMicrosoft Office Solved unable to delete or add worksheets in an Excel spreadsheet Tags:DELETEspreadsheet NicFurr March 13, 2013 at 09:17:54 Specs: Windows 7 Register To Reply 04-30-2006,02:45 PM #2 Debra Dalgleish Guest Re: can't delete worksheet--grayed out! Code: Worksheets("whateverthenameis").Rows("205:1048576").EntireRow.Delete Worksheets("samename").Range("V1:IV1").EntireColumn.Delete or something like that.

Delete Sheet Greyed Out Excel 2013

I finally at least got the timestamp to change so it looks like I've done something to my file, but no sheets are deleted. http://www.computing.net/answers/office/unable-to-delete-or-add-worksheets-in-an-excel-spreadsheet/17977.html Why can't I delete my Excel worksheet? Unable To Delete Sheet In Excel 2010 Can anyone explain? Can't Delete Sheet In Excel 2016 The Menu:Edit>Sheet>Delete option is disabled.

I just registered and copied the "Reactivate..." code above and executed it without change of these sheet tab options. click site I had inadvertently added a password disallowing sheets to be added or deleted. Join over 733,556 other people just like you! Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Delete Sheet Option Is Disabled In Excel 2007

No, create an account now. That's weird. Thanks, ### __________________ 2016 AO NFL Full Season Pick'em Contest - A Dab Free Zone Winner Announced!!! http://magicnewspaper.com/in-excel/zero-not-saving-in-excel-worksheet.html Hi there!

Share Share this post on Digg Del.icio.us Technorati Twitter Regards, Zack Barresse My Book on Excel Tables My Blog @ ExcelTables.com (If you would like comments in any code, please say Delete Option Greyed Out In Excel If this is your first visit, be sure to check out the FAQ by clicking the link above. Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New?

Is there any code running that might disable that menu option?

Tech Support Guy is completely free -- paid for by advertisers and donations. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like this thread? What error did you get when you ran this line - bearing in mind that it should delete the first sheet in your workbook? Excel 2016 Unshare Workbook Why can't I delete my Excel worksheet?

Please Login or Register to view this content. May 19, 2015 by asanchez192. However, the Thread Tools Search this Thread 12-14-2005, 02:22 AM #1 fooddestroyer Registered Member Join Date: Sep 2004 Location: N.Ireland Posts: 274 OS: XP I want to More about the author This can happen in one workbook, and it will disable it for ALL Excel workbooks (in other words the entire application).

Choose less data or close other applications." message. No change- "Delete Sheet" still grayed (greyed?) out. Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search These kinds of threads have helped me quite a bit over the years.

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote May 11th, 2004,11:56 AM #9 Zack Barresse MrExcel MVP Join Date Dec 2003 Location Oregon, USA Posts 10,650 Tools There are 10 kinds of people in this world. I entered the above code in a sub, saved the code, saved the workbook, closed Excel, even rebooted my computer but still cannot delete worksheets in any workbook. Basically, it is all the same question - why is the code I am executing to delete a w/s not deleting the w/s?