I want to delete w worksheet. Under edit, delete, 'delete sheet' is grayed
out. When I left click on the tab, it is grayed out. Under tools, protection,
'protect worksheet' is grayed out. Any suggestions?
PCLIVE - 06 Nov 2006 19:08 GMT
Workbook is probably shared.
Tools-Share Workbook.
Regards,
Paul
>I want to delete w worksheet. Under edit, delete, 'delete sheet' is grayed
> out. When I left click on the tab, it is grayed out. Under tools,
> protection,
> 'protect worksheet' is grayed out. Any suggestions?
Don - 06 Nov 2006 19:09 GMT
Check to ensure that you are not "editing" a cell in the workbook or there
are no message boxes that need attention.
Don
>I want to delete w worksheet. Under edit, delete, 'delete sheet' is grayed
> out. When I left click on the tab, it is grayed out. Under tools,
> protection,
> 'protect worksheet' is grayed out. Any suggestions?
Gord Dibben - 06 Nov 2006 23:30 GMT
Sheet protection does not prevent deleting the sheet, just prtects changes to
the sheet.
You may have workbook protection enabled. Have a look there or at Tools>Share
Workbook.
If workbook is shared you cannot delete sheets.
Gord Dibben MS Excel MVP
>I want to delete w worksheet. Under edit, delete, 'delete sheet' is grayed
>out. When I left click on the tab, it is grayed out. Under tools, protection,
>'protect worksheet' is grayed out. Any suggestions?