Hi,
This is my first post to this group, so here goes.

I have a macro that reads from an array and then creates a new tab for each item in the array, it then sets up a template on each of the newly created tabs.

My problem is that I want to add a very simple macro to each new tab as well.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    ChangeLog
End Sub
I can do this manually but would really like to automate this portion as well as there could be 25 or more sheets created.

Is this even possible.

Please let me know if you need further clarification.

Thanks,
JT