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?
 
The workbook is either protected or shared


--


Regards,


Peo Sjoblom
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting Worksheet in excel = 2003 / 2007 1
list of all subdirectories in a given directory in excel 3
Clear excess formats in Excel 2007 3
Excel 07 worksheet problem - HELP!! 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
rename worksheet tabs 2
Excell 2021 0
How to delete blank worksheets 1

Back
Top