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.

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.

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