Enable "Delete Worksheet" in macro-enabled workbook

[thoabui]

I have a macro-enabled workbook with a lot of worksheets. I am trying to delete/replace a worksheet but "Delete Sheet" is grayed out in both the "Edit" menu and RtMouseClick menu. "Insert Sheet" is also grayed out. The sheet is not protected and the workbook is not shared. Can someone please help? Thanks!

 

[VoG]

Is the workbook (structure) protected?

 

[thoabui]

I'm not sure as I didn't create it. How do I verify if it is or not? The worksheets are individually protected. I've unprotected the one that needs to be replaced/deleted.

 

[VoG]

In Excel 2003 and earlier, Tools > Protection.

In later versions check the Review tab.

 

[thoabui]

No, it is not protected.