Unable to delete or insert a worksheet.

D

dmarten

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.
 
J

Jason M

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.
 
D

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.
 
Top