changing Tab Colour & Name to match

Hi,

Can someone please help me with the code to change the tab colour and name to match with a cell in a single sheet?

Say sheet name "Overview" contains the reference cells say from A7 onwards.

So for example Sheet2 would be renamed to the A7 which is OM50077 for example. Then if i change the colour of cell A7 to green, Sheet2 (now renamed OM50077) also changes it's tab colour to match the cell Overview!A7 colour.

The list from A7 will continue downwards say to A100.

Thanks!!!

Hi

How about

Please Login or Register  to view this content.

rylo