Add code automatically to a sheet as it is inserted

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 worksheet is:

Private Sub AddNewProduct_Click()
form_AddNewProduct.Show
End Sub

Many thanks in advance

@ Norie
Code I used recently for a right click event on a excel output
I had spotted that but had not a chance to assign to find a way to write to an ordinary Sub routine. Too many distractions today unfortunately...

Hi !

As the easy way is to copy a template worksheet which has already the code but yes it's too obvious …

as its in same workbook

Please Login or Register  to view this content.