Changing Tab names in VBA#

[narked]

Hello chaps,

newbie question for you. I have looked at some of the other entries about this and nothing really fits what I need.

i have a work book with a list of names, and each name realtes to a seperate tab, 14 names in total, with a sheet at the end that collates figures from all of the sheets.
I want to put a macro/vba code in to automatically change the names of the 14 tabs when the names in the list are amended
I've tried different combinations but nothing really seems to fit, even tried linking the macro to a control button but that hasnt worked either

does anyone have anything that might fit the bill? still getting to grips with the VBA thing but moving forward every day...


thanks in advance chaps

 

[VoG]

Maybe this. Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets(Target.Row).Name = Target.Value
End Sub