Unable to delete or insert a worksheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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