non editable element in excel workbook

[newsil]

I have an Excel workbook containing sheets and a lot of VBA code

I have a Login sheet which is used to identify user and then load data from an external database, and to create data validations (drop-down list) in some sheets.

Sometimes I get an error message when I open the file (before login and data loading), then I get an new item in the sheet list visible only in the VBA editor and unmanageable (I can neither modify nor delete it) even when I select it the Property window only displays the properties of the workbook (shuRech in the photo).

The new element takes the name of an existing sheet and the original sheet is renamed ([sheet_name]1) and all formatting is removed, only the plain text is kept (shuRech1 in the photo)

I've copied the infected sheet from a backup and it works, but I can't delete the added element

How can I delete this item without redoing the whole workbook again?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: non editable element in excel workbook
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.