| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I delete a worksheet from my workbook
I need to delete an empty worksheet from my workbook. Although I have tried
2 options:- (a) edit menu, delete sheet (b) select sheet, right click and then delete sheet In both options the words "delete sheet" are dimmed and I am therefore unable to delete the sheet. It is a shared workbook |
|
#2
|
|||
|
|||
|
Is your workbook protected?
"DLee" wrote: I need to delete an empty worksheet from my workbook. Although I have tried 2 options:- (a) edit menu, delete sheet (b) select sheet, right click and then delete sheet In both options the words "delete sheet" are dimmed and I am therefore unable to delete the sheet. It is a shared workbook |
|
#3
|
|||
|
|||
|
You cannot delete sheets from shared workbooks.
Un-share it first then delete the sheet. Gord Dibben Excel MVP On Mon, 15 Aug 2005 13:40:03 -0700, "DLee" wrote: I need to delete an empty worksheet from my workbook. Although I have tried 2 options:- (a) edit menu, delete sheet (b) select sheet, right click and then delete sheet In both options the words "delete sheet" are dimmed and I am therefore unable to delete the sheet. It is a shared workbook |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help - now really stuck! File transfer problem | Excel Discussion (Misc queries) | |||
| Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
| How to control worksheet initialization upon opening a workbook | Excel Worksheet Functions | |||
Linear Mode
