Sheet Name Properties

Many Thanks to all of the MVPs who answer questions here!!

In the VBE window, if the Properties pane is open, worksheets have two name properties:

• the first is the (Name) property and can be changed in the properties pane.

• and the second is the Name property and it can be changed either by code or by changing the name on the tab itself.

The (Name) property may be used very much like using ThisWorkbook to refer directly to a worksheet without having to use the tab name.

The worksheet tab name can be returned by using

Dim shName As String
    shName = ActiveSheet.Name

Is there a way to return (or change) the (Name) property as in the VBE properties pane?

Maybe

ThisWorkbook.VBProject.VBComponents("Sheet2").Name = "YourNameHere"

see link for more

http://www.cpearson.com/excel/codemods.htm

VBA Noob

As always you guys are great!

Your welcome

VBA Noob