Hi Sixthsense,


The code works great! Thank you. However, how can I tweak it so that all four tabs are renamed at exactly the moment the text is entered in the first tab in cell D9? So, this would be a change event related to that cell? The tabs would not have the same name as the text entered in cell D9 since the value entered in cell D9 would be appended as the prefix with a space between to the existing tab names like this:

D9 = OAC

Tab 1 = 123 becomes OAC 123
Tab 2 = 789 becomes OAC 789
Tab 3 = 456 becomes OAC 456

Thanks

With Sixthsense' help from above and some tweaking of my own I have solved the riddle.

Thus, any time cell D9 has an entry made to it whether adding in an entry or deleting an entry the tabs will update. When adding an entry the tabs will have the entry added as a prefix to the already existing tab name with a space between the newly added prefix and existing tab name.

Also, when the entry in cell D9 is deleted, the tabs will revert back to their original tab names with the prefix being removed.

Pretty cool ha? Here is the code which needs to be added to the sheet object where cell D9 will be updated in project explorer.