View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RV RV is offline
external usenet poster
 
Posts: 11
Default Changing of Sheet Codes for the worksheets...

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