VBA Excel to add the date and time in a column in every new excel sheet

[Nadersa]

how to create a VBA Excel to add the date and time in a column in every new excel sheet? please write full macro.

Thanks,

 

[MARK858]

You don't say where in the column (or what column) so it places the date/time in A1.
The code must go in the ThisWorkbook module of the workbook.

Private Sub Workbook_NewSheet(ByVal Sh As Object)
    Sh.Cells(1, 1) = Now
    Sh.Columns(1).AutoFit
End Sub