Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Printing separate sheets on one paper sheet | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |