Read the VBA help menu on codename

Its possible for the sheet name to be different from the code name. When
you create a sheet, the sheet name and code name are the same, but changing
the sheet name doesnt change the code name, and changing the code name
(using the Properties window in the Visual Basic Editor) doesnt change the
sheet name.

Note The value that you see in the cell to the right of (Name) in the
Properties window is the code name of the selected object. At design time,
you can change the code name of an object by changing this value. You cannot
programmatically change this property at run time.



"RV" wrote:

Hi,

I using the worksheet code obtained using CodeName property of the
worksheet object. Before saving the workbook, I just reshuffled the
worksheets in the workbook by moving them. Now if I just reopen this saved
workbook, to my surprise I found that the code name returned using
the CodeName property on worksheet object is different from that used to
returned when the workbook was opened first time.

I have found on other sites that CodeName for worksheet never changes.

Can anyone please clear my concept on the CodeName?

Thanks and With Warm Regads,

-Rahul Vakil