Private Sub Workbook_NewSheet(ByVal Sh As Object) If TypeName(Sh) = "Worksheet" Then Sh.Cells.ColumnWidth = 35 Sh.Range("A1") = "Sheet added " & Now() End If End Sub