| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to delete or insert a worksheet.
I have a workbook opened locally on my desktop. It is not protected,
read-only, or shared. Yet I cannot insert a worksheet nor can I delete an existing worksheet. These items on the Edit menu are grayed out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unable to delete or insert a worksheet.
Sounds like the creator of the file has VBA code in place to restrict those
functions. I experienced the same thing with a file that was sent to me. I am not a VBA expert, but I think if you look for that code and delete it, then you should be about to use the edit features. "dmarten" wrote: I have a workbook opened locally on my desktop. It is not protected, read-only, or shared. Yet I cannot insert a worksheet nor can I delete an existing worksheet. These items on the Edit menu are grayed out. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unable to delete or insert a worksheet.
I'd double check that workbook protection setting.
Tools|Protection If you see unprotect workbook, then try that. You may need to supply a password. dmarten wrote: I have a workbook opened locally on my desktop. It is not protected, read-only, or shared. Yet I cannot insert a worksheet nor can I delete an existing worksheet. These items on the Edit menu are grayed out. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| Wish to add a WORKSHEET but 'WORKSHEET' not open in 'INSERT' | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
| MY WORKBOOK WON'T LET INSERT ANOTHER WORKSHEET. | Excel Worksheet Functions | |||
Linear Mode
