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

Welcome to the forum
Sheet6 (Download_Liquidity_Views)

Sheet6 is the equivalent of VBA sheets(6) = the 6th sheet - you CANNOT change it. If you move the worksheet then it will change to its new position in the workbook
Download_Liquidity_Views is the Tab name - you can change it

Hey thanks! :-)
I may have just said it incorrectly. My goal is the following.
I created Sheet6 (Download_Liquidity_Views) via VBA code.
But I wanted to generate something like:

Download_PP_Views (Download_PP_Views)
which can be seen a few lines above and which is probably created via Excel directly. But I am not sure. I took over the VBA code and have to amend it now for the Liquidiy download. I amanged to get it to run but is behaves differently than the Download_PP_Views worksheet object.

In VBA click on "View" and select "Properties Window" - and edit the name of the object there

You are a genius!!!! :-) Many thanks!

In VBA click on "View" and select "Properties Window"

As mentioned in your other thread for this issue.

You are welcome.
If that sorts your problem, click on Thread Tools (top of thread) and mark thread as solved.
Thanks