Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

[Excel] Using the (Name) property

Status
Not open for further replies.

Skullmonkey

Computer
Joined
Dec 10, 2001
Messages
12
Location
US
I'm interested in writing code in which I can use the name I've given to a particular object inside the VBAProject window. For instance, when looking at the Properties of a chart in the VBA Editor | VBAProject Explorer, one sees many options, one of which is called "(Name)".

Does anyone know how to use this property inside of VBA code? If my declaration of this chart did not include the tab name, the code would not fault if the user renamed the tab.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top