Unwanted sheet in VBE

Tam

As Willie says, the ThisWorkbook object is in every Excel file and cannot be deleted.

The Sheet5 seems to be a shadow copy of that and I don't know how it was created. It's empty and does nothing but...

In the attached revised file, I've:

1. copied all modules from your file
2. copied your worksheet "macros" and:

•      aligned/ resized all the buttons to give a neater, more uniform look
•      assigned the correct macro to each button (to match the assignments in your file)..

As a consequence, you no longer have the mysterious Sheet5 in VB Project Explorer.

Hope this fixes your problem (given Excel's insistence on ThisWorkbook). If so, please be sure to mark this Answer as Selected. (Also, kindly act on my comments against your "Answer").

 Hello Tam and welcome to the forum,

I have added a screenshot with notes to your file. (attached)

The "ThisWorkbook" object is present in all files and shows in the "VBAProject" window. Without getting technical, it basically represents the whole Excel file. It cannot be removed.

The "Sheet5" object is a worksheet. To view its properties, select it and scroll down to the "Properties" window. In your case, look at the last property - Visible. It is likely set to "xlSheetHidden" or "xlSheetVeryHidden". Change this to "xlSheetVisible" to see the worksheet in Excel. After the sheet is visible you can decide whether to keep it or delete it.

UPDATE - Dec. 20

Uploading your file has provided some good answers. Your situation is something I have never seen or heard of before. Your "Sheet5" is a copy/duplicate of the "ThisWorkbook" object. I don't know how this is possible. Totally bizarre. If you open the VB Editor and select "Sheet5" in the VBAProject window (top left) and then look at the Properties window (bottom left) you will notice the title reads "Properties – Sheet5" and the first line (Names) reads "ThisWorkbook"; it should read "Sheet5". Now select "ThisWorkbook" in the project window. Now look at the Properties window and you will notice everything is the same. The title should be "Properties – ThisWorkbook" but it reads "Sheet5"

If I were you, this is what I would do: Create a new Excel macro enabled (.xslm) workbook. In the VB Editor add 20 modules (like your "tools" file). Then, one-by-one, copy the code from old Module1 to new Module1, old Module2 to new Module2, etc. in the new workbook. Copy worksheet "macros" to the new workbook. Check each button on this new sheet to make sure each button is assigned to the macro in the new workbook and not the old (original) workbook. After verifying everything in the new workbook is as it should be, delete the original, and then rename the new workbook to "toosl.xslm"

I have updated my file to include screen shots of these oddities.

If this answers your question please mark my answer as Selected.

Cheers   :-)