how can worksheets be deleted in Excel?

  • Thread starter Thread starter Duffer
  • Start date Start date
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?
 
Is the workbook protected under Tools>Protection>Protect Workbook?


Gord Dibben MS Excel MVP
 
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.
 
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
 
Back
Top