Use VBA to add code to sheet as inserted

[Christian S]

Hi all,

My current sheet has a macro that uses a userform to add a new named sheet (eg. 'Coats'). Is there any code i can use in my userform module to then add some code automatically to the coats worksheet module as it is inserted?

The code i'm looking to add to the module is
Private Sub AddNewProduct_Click() form_AddNewProduct.Show
End Sub

Many thanks in advance

 

[KOKOSEK]

Cross post, solved there https://www.excelforum.com/excel-pr...tomatically-to-a-sheet-as-it-is-inserted.html