| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deleting worksheets from workbook when option not available
I am trying to delete worksheets from a workbook and the option for deleting
sheets is not available it is greyed out. Is there anything I can do to make that option available. Thanks, Rita318 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
deleting worksheets from workbook when option not available
Hi Rita
Is the workbook protected? Go ToolsProtection and look to see if you have an Unprotect option. You would need to click that before you can delete the sheets. Hope this helps! Richard Rita318 wrote: I am trying to delete worksheets from a workbook and the option for deleting sheets is not available it is greyed out. Is there anything I can do to make that option available. Thanks, Rita318 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
deleting worksheets from workbook when option not available
It sounds like the workbook is protected so un-protect it
Mike "Rita318" wrote: I am trying to delete worksheets from a workbook and the option for deleting sheets is not available it is greyed out. Is there anything I can do to make that option available. Thanks, Rita318 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
deleting worksheets from workbook when option not available
Rita
Also, if the workbook is Shared you cannot delete sheets. Do you see [Shared] in the title bar? Gord Dibben MS Excel MVP On 4 Jan 2007 05:58:25 -0800, "RichardSchollar" wrote: Hi Rita Is the workbook protected? Go ToolsProtection and look to see if you have an Unprotect option. You would need to click that before you can delete the sheets. Hope this helps! Richard Rita318 wrote: I am trying to delete worksheets from a workbook and the option for deleting sheets is not available it is greyed out. Is there anything I can do to make that option available. Thanks, Rita318 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data referencing and auto fill across worksheets in one workbook.. | Excel Worksheet Functions | |||
| How do I open several worksheets from the same workbook on screen | Excel Worksheet Functions | |||
| Multiple worksheets within a workbook | Excel Worksheet Functions | |||
| How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) | |||
| How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
