Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't delete a whole sheet in Excel. Option is grayed out.
I am trying to delete sheets but the option is grayed out.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't delete a whole sheet in Excel. Option is grayed out.
Tommy
I would presume you have the Workbook protected or it is shared. Have a look at ToolsProtection for options available. If workbook is protected "unprotect workbook" will be an option. If protected, you may need a password to unprotect. If not the case, look under ToolsShare Workbook and unshare it if shared. Gord Dibben Excel MVP On Mon, 28 Nov 2005 09:46:13 -0800, "Tommyboy" wrote: I am trying to delete sheets but the option is grayed out. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't delete a whole sheet in Excel. Option is grayed out.
Thanks Gord. The problem is that the workbook was shared. Works great now.
Tommy "Gord Dibben" wrote: Tommy I would presume you have the Workbook protected or it is shared. Have a look at ToolsProtection for options available. If workbook is protected "unprotect workbook" will be an option. If protected, you may need a password to unprotect. If not the case, look under ToolsShare Workbook and unshare it if shared. Gord Dibben Excel MVP On Mon, 28 Nov 2005 09:46:13 -0800, "Tommyboy" wrote: I am trying to delete sheets but the option is grayed out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - automatic information from one sheet to another?? | Excel Discussion (Misc queries) | |||
the option "sent to" mail recipient is not available in excel 200 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |