deleting sheets
 

i have a Excel document that i am trying to delete a sheet from...

when i right click on the sheet, the "delete" option is grayed out
same thing when i go to EDIT, DELETE SHEET

i thought at first that there was some kind of protection,
but when i go to TOOLS, PROTECTION
it's also grayed out!

any suggestions?

It sounds like something is interfering with your toolbars.

If it happens with all your workbooks, then I'd try resetting all my toolbars at
once.
(This will toss all your customizations!)

Close excel
windows start button|search|*.xlb
Rename them to *.xlbOLD

Start up excel and test it out.

If it worked ok, then delete those *.xlbOLD files and start recreating any
customizations.

===
If it only happens on one workbook (and the problem goes away when you close
that workbook), then it sounds to me like the developer didn't want you to
delete the sheet. I try to track that person down (if it isn't you!) and ask
why.

(If you were the developer, I'd just do the first suggestion.)

KLP wrote:

i have a Excel document that i am trying to delete a sheet from...

when i right click on the sheet, the "delete" option is grayed out
same thing when i go to EDIT, DELETE SHEET

i thought at first that there was some kind of protection,
but when i go to TOOLS, PROTECTION
it's also grayed out!

any suggestions?

--

Dave Peterson

Hi KLP,

Is the workbook shared - intentionally or unintentionally?


---
Regards,
Norman



"KLP" wrote in message
...
i have a Excel document that i am trying to delete a sheet from...

when i right click on the sheet, the "delete" option is grayed out
same thing when i go to EDIT, DELETE SHEET

i thought at first that there was some kind of protection,
but when i go to TOOLS, PROTECTION
it's also grayed out!

any suggestions?

Much better answer!

Norman Jones wrote:

Hi KLP,

Is the workbook shared - intentionally or unintentionally?

---
Regards,
Norman

"KLP" wrote in message
...
i have a Excel document that i am trying to delete a sheet from...

when i right click on the sheet, the "delete" option is grayed out
same thing when i go to EDIT, DELETE SHEET

i thought at first that there was some kind of protection,
but when i go to TOOLS, PROTECTION
it's also grayed out!

any suggestions?


--

Dave Peterson