I have sheets that are listed in an Excel workbook that do not actually exist. Sheets are listed when viewing the code and look at the list of sheets in the VBA part, but they do not exist at all in the workbook. They are also not hidden if someone thinks about it.
These sheets also do not have a name after them in parentheses and look like the same icon as ThisWorkbook. I have no way to remove them and try. Anyone have suggestions for removing them from the VBA part? Remember that these worksheets do not actually exist, so I cannot just right-click them in Excel and select Delete. I tried to right-click on a sheet in VBA and select "Delete Sheet", but this option is inactive. In fact, deleting a sheet will be gray on all sheets, even those that exist. The spreadsheet is also not secure.
These sheets do not cause any problems, they are more annoying, since I know that they do not physically exist, and I have no way to remove them from VBA. I have attached a photograph of what I am watching. The sheets I'm trying to delete are Sheet10, Sheet11 and Sheet9.
