Solved: Rename "Microsoft Excel Objects"

[zaboo9]

Say I have 3 Excel sheets, I re-named them: Uno, Dos, Tres by right clicking on each tab, selecting "Rename," and naming them.

When I go to VBA, there is a list on the left that will show all 3 of these sheets under a folder called "Microsoft Excel Objects." It will say
Sheet1 (Uno)
Sheet2 (Dos)
Sheet3(Tres)

How do I change the objects to say:
Uno (Uno)
Dos (Dos)
Tres (Tres)

I know this is super easy, but I have searched and can't find how to do this. Thanks!

[Bob Phillips]

Select that object in the VBIDE, and in the properties window you will see its codename (for that is what it is called) as the (Name) property. You can change it there.

[zaboo9]

I am in the VBIDE, but I don't see any properties window when I double click on
Sheet1 (Uno) or
Sheet2 (Dos) or
Sheet3(Tres)

when I double click on them, it just opens the sheet to code.

How do I make the properties window show up? Thank you for the help.

[zaboo9]

I'm using Excel 2003, btw.

[Bob Phillips]

I didn't say double-click it, I said select it.

Also, make sure the properties window is open, F4.

[GTO]

In VBIDE, from the menu bar, View|Properties Window

[zaboo9]

There it is! Thank you so much for the help!