adjustment in vba properties editor for sheet tabs and merging of codes

Hi All
Can a macro make a change in the sheet name box in the vba properties editor for two sheets Wsworkings for workings sheet tab and Ws master as Master sheet tab.

Actually I have to this manually

Take note I did note write the vba code below

The two codes are run individually, if they could merge I would be happy .

Issue can the the WsMaster and Wsworkings be done automatically and merging the two vba code

manually add Wsworkings and Ws master in vba editor

The Add bridge_1 is run first then subcopyspecific code

Please Login or Register  to view this content.

Workings Sheet Tab

Please Login or Register  to view this content.

Are you trying to change the sheet name (the one in brackets) or the sheet codename (the other one)? If it's the other one - not in brackets - then:

Please Login or Register  to view this content.

Note that to access the codename you need access to the VBAProject - goto macro settings and set "Trust access to the VBA object model".

The other questions about merging the code ... if it's just a case of running them one after the other rather than separately, just create a new sub:

Please Login or Register  to view this content.