I cannot get rid of these extra sheets in excel vba. only the sheets with a name exist

Question

I cannot get rid of these extra sheets in excel vba. only the sheets with a name exist.

*How* are you trying to "get rid" of these sheets? Please add that code to your post. — Hans Keﬆing, Mar 24 '17 at 13:40
Is this link similar? https://superuser.com/questions/1005482/excel-creates-non-existent-worksheets-in-vba-project-explorer — Darren Bartrup-Cook, Mar 24 '17 at 14:54

score 0 · Answer 1 · answered May 01 '20 at 03:54

I had exactly the same problem. I used the option Book Inspection in the Information Menu, then I selected remove hidden objects and it luckily worked. See the image attached, my excel is in Spanish so maybe the option is not really called "Book inspection" in the English version.

Hope this is useful.

Pd- Unhide the legitimate sheets because it will delete all hidden sheets. I suggest trying it in a copy of the book. Menu Option

I cannot get rid of these extra sheets in excel vba. only the sheets with a name exist

1 Answers1