zaboo9
06-30-2010, 10:37 AM
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!
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!