Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to delete sheets but the option is grayed out.
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |