how can worksheets be deleted in Excel?

D

Duffer

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?
 
G

Gord Dibben

Is the workbook protected under Tools>Protection>Protect Workbook?


Gord Dibben MS Excel MVP
 
D

Duffer

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.
 
G

Gord Dibben

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
 
Top