tab lables

[Deeks]

Hi all

this could be impossible but I was wondering if it is possible to use one of the worksheets to label the tabs below. I am setting up a workbook at the school I teach in and will label the tabs with the teachers names. However another school would be able to use the same workbook and add their teachers names to a sheet and have them change the tab names.

It could be ridiculous but I thought it was worth a shot.

Thanks
Deeks

[arlu1201]

You can do this using a macro. You can have the tab names listed in one of the sheets and the macro will name each of the other sheets as per the list.