I have a macro that automatically controls the format of cells in a worksheet.
Example:
Sheet1
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Range("A1").EntireColumn.AutoFit
End Sub


Now I want make a macro that insert a new worksheet and the loads this
automatic macro into the new worksheet. Is this possible?

BR
Trond