Home > In Excel > Unable To Delete Worksheet In Excel 2010

Unable To Delete Worksheet In Excel 2010

Contents

I unselected the add-ins, which is just analysis tool pack, morefunc, and '07 converter, closed,opened still greyed out so it is not the add-ins causing this. Everything in the Visual Basics toolbar works as it should. All other functionality in the Page Setup is unaffected. UNLESS of course, there is an offending workbook you are using that may keep turning it off. this contact form

If so, delete the code...you don't need it anymore. Thanks. > > Register To Reply 05-01-2006,09:40 PM #4 TDiesel216 Guest Re: can't delete worksheet--grayed out! Any help you can offer is > > > much appreciated! The sheet isn't protected which is puzzling since I can't get the mouse to even highlight any of the greyed out areas. http://www.computing.net/answers/office/unable-to-delete-or-add-worksheets-in-an-excel-spreadsheet/17977.html

Unable To Delete Sheet In Excel 2013

Trouble is I've forgotten how to unhide those columns. is greyed out. Computing.Net and Purch hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy.

  • Delete worksheets None Merge cells or split merged cells None Add or change conditional formats Existing conditional formats continue to appear as cell values change, but you can't change these formats
  • If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.
  • For more information about the Microsoft Backstage Button, see What and where is the Backstage?
  • Then hold down SHIFT while you click the tab for the last sheet that you want to select.
  • You can't delete sheets from a shared workbook.
  • If I 'move & copy' the workbook the functions on the copied workbook are then active.

I personally don't like Shared Workbooks. Ask Your Own Question Application.commandbars Not Working - Excel Excel Forum Hi All, I want to deactivate "Delete row column" operations on workbook, so I have created a Add-Ins and excecuting Insert or change pictures or other objects You can view existing pictures and objects. Can't Delete Sheet In Excel 2016 I wish to remove the name assigned but not the actual range of referenced cells.

How to Add, Remove, and Rearrange Columns and Rows in Excel Adding, removing and rearranging columns is as easy as resizing. Delete Sheet Greyed Out Excel 2013 Click Tools -> Protection -> Unprotect Workbook. Ask Your Own Question Privacy Policy | Disclaimer Copyright © 2016 Excel Help - We are not affiliated with Microsoft. If this answer helps, please click the Vote as Helpful button.

Please rotate dial by 90 degrees and try again." 12-14-2005, 04:31 AM #3 fooddestroyer Registered Member Join Date: Sep 2004 Location: N.Ireland Posts: 274 OS: XP nope- Unable To Delete Sheet In Excel 2016 are greyed out except view code and Protect Sheet. If your question is resolved, mark it SOLVED using the thread tools 3. The name (or title) of a worksheet appears on its sheet tab at the bottom of the screen.

Delete Sheet Greyed Out Excel 2013

No, create an account now. https://forums.techguy.org/threads/resolved-excel-cant-delete-worksheet.51280/ My workbook/sheet is not shared. Unable To Delete Sheet In Excel 2013 Cheers, Shane Devenshire Marked as answer by Sally Tang Monday, September 20, 2010 7:01 AM Saturday, September 18, 2010 11:33 PM Reply | Quote All replies 0 Sign in to vote How To Delete A Worksheet In Excel 2010 Write, record, change, view, or assign macros You can run existing macros that don't access unavailable features.

I have not protected the workbook and the unprotect sheet function is now greyed out. weblink If I have helped, Don't forget to add to my reputation (click on the star below the post) Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) Use Insert automatic subtotals You can view existing subtotals. Code: Sub DeleteCommand() Application.CommandBars("Cell").Controls("Delete...").Delete Application.CommandBars("Row").Controls("Delete").Delete Application.CommandBars("Column").Controls("Delete").Delete End Sub But on few systems it's not working properly.... Excel Delete Sheet Greyed Out

If this answer helps, please click the Vote as Helpful button. Did Donald Trump say that "global warming was a hoax invented by the Chinese"? Use a data form to add new data You can use a data form to find a record. navigate here Add or change data validation Cells continue to be validated when you type new values, but you can't change existing data validation settings.

Can I use pivottables in a shared workbook? How To Enable Delete Sheet Option In Excel 2007 What steps do you suggest trying? If I right click on an individual column the option is there but it does not sort it correctly.

Click the File tab.

Register To Reply 09-18-2013,12:58 PM #8 kris75 View Profile View Forum Posts Registered User Join Date 12-21-2009 Location North East, England MS-Off Ver Excel 2003 Posts 2 Re: can't delete worksheet--grayed Create or change charts or PivotChart reports You can view existing charts and reports. Please Login or Register to view this content. Excel 2010 Unshare Workbook Linkmaster, Aug 21, 2001 #2 jimi Thread Starter Joined: Jun 14, 2000 Messages: 3,941 this "problem" is solved, we are running a peer to peer network and most users have a

Maybe firefytr means that your wb is locked by a workbook protection and not a sheet protection..just a wild guess Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Tip: You can also right-click the selected sheet tabs, and then click Insert. Delete worksheets None Merge cells or split merged cells None Add or change conditional formats Existing conditional formats continue to appear as cell values change, but you can't change these formats his comment is here Loading...