Sub 生成日报表()
Dim sht As Worksheet, i As Integer
i = Worksheets.Count - 1
Worksheets("工作表模板").Visible = True
Worksheets("工作表模板").Copy after:=Worksheets(Worksheets.Count)
Set sht = ActiveSheet
sht.Name = i & "日报表"
Worksheets("工作表模板").Visible = False
End Sub