Microsoft Excel Objects (two different worksheet types)

Hi there, I see two different types of worksheet objects.

See the attached pic. I tried to change the "names" of the worksheets that start with "Sheet6" but couldn't. I could only change the name that appreas in brackets.
Thanks a lot!
Tom

There are 2 worksheet 'names'. One is the Tab name (as appears on the sheet tab) and the other is the Code name.

The Tab name can be changed by code, the code name cannot. It can only be changed manually in the Properties Window for the worksheet.

Guessing. There is no attachment to view your issue.