Is 'ThisWorkbook' a code name or sheet name (shown in braces in 'project explorer' window)? For me excel will not allow to have two the same code names (for workbook and worksheet).
How do you try to delete the sheet - by code or UI? Is the workbook protected (structure)?
In the VBE window it is just Sheet7. There is no name after it like eg. Sheet6(Planner). In the properties window it has all the same sort of attributes as 'ThisWorkbook' and in the name field of the properties (name) ThisWorkbook.
I have tried to delete it via the UI. If you go back to excel the sheet is not visible.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.