Unable to delete or insert a worksheet.

[Guest]

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.

 

[Guest]

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.

 

[Dave Peterson]

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.