I used to be able to delete excess worksheets in an Excel file. I can't do
that anymore in Excel 2003. The choices for "Delete" and "Rename" are faded
out and not choosable. Any ideas?

The workbook is either protected or shared


--


Regards,


Peo Sjoblom


"Duffer" wrote in message
...
I used to be able to delete excess worksheets in an Excel file. I can't do
that anymore in Excel 2003. The choices for "Delete" and "Rename" are
faded
out and not choosable. Any ideas?

Is the workbook protected under ToolsProtectionProtect Workbook?


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 08:50:01 -0800, Duffer
wrote:

I used to be able to delete excess worksheets in an Excel file. I can't do
that anymore in Excel 2003. The choices for "Delete" and "Rename" are faded
out and not choosable. Any ideas?

The worksheet is neither marked as protected or shared (as best as I can
tell). But still can't do anything with the junk sheets.

"Duffer" wrote:

I used to be able to delete excess worksheets in an Excel file. I can't do
that anymore in Excel 2003. The choices for "Delete" and "Rename" are faded
out and not choosable. Any ideas?

No one mentioned that the workSHEET was protected.

If the workBOOK was protected delete sheet and rename sheet would be grayed out.

If the workbook is shared you could rename but not delete.


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 11:58:01 -0800, Duffer
wrote:

The worksheet is neither marked as protected or shared (as best as I can
tell). But still can't do anything with the junk sheets.

"Duffer" wrote:

I used to be able to delete excess worksheets in an Excel file. I can't do
that anymore in Excel 2003. The choices for "Delete" and "Rename" are faded
out and not choosable. Any ideas?