can a macro change the sheet name (the one in the VBA editor)

[tonywatsonhelp]

Hi everyone,
as you all know every sheet has two names,
please excuse me for not know what there are both called

but as an example if i look in the VBA window at the sheets i see this "Sheet1 (Sheet1)"
so i know how to rename the second name (the one one that shows in the tab, but i need to change the first one?
can this be done and if so how
Thanks
Tony

 

[StephenCrump]

You can change a worksheet's codename like this:

Sheet1.[_CodeName]="SomeNewName"

(Thanks to Jaafar Tribak for this - see Post #12 here - much easier than the alternatives that rely on the user's security settings)
Change Worksheet Codename

 

[tonywatsonhelp]

Wow, this is huge,
thank you very much Stephen (and Jaafar)
Thanks
Tony