Automatically inserting macro into new sheets

[snowboy001]

I am working on a sheet that has code put in each worksheet for change tracking. This is something that many other people are going to be using, and I would really like to make it as "idiot-proof" as possible. Is there any way that each time a new sheet is inserted, the code for the worksheets is automatically entered? It is the same code for each sheet, so there is no worry about changes to any of the format.

 

[harshab6]

hi,
Once we write a macro for the workbook i automatically works for inserted sheet and also the new workbook saved opened after opening a workbook contaning macro.press ALT F8 when box opens containing macro select a particular macro. below there is macro-in with scroll downs select open all workbooks save close and reopen the sheet containing macro.

hope this helps
regards
harsha

 

[snowboy001]

Not quite. I need the code from "Sheet1" to be pasted into the code for each new sheet that is added to the workbook automatically, that way no one has to go in and make changes to the macro coding.

 

[snowboy001]

Figured it out. I just wrote in code to copy the sheet, rename it, clear the contents and move it to the end.