1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Sub CreateSheet(sMonth As String)
Dim i As Byte
Dim cmdNew As Variant
Worksheets.Add after:=Sheets(Worksheets.Count)
ActiveSheet.Name = sMonth
Rows(1).RowHeight = 50
Rows(2).RowHeight = 28
For i = 1 To 7
Columns(i).ColumnWidth = 11
Next i
Columns(4).ColumnWidth = 65
Set cmdNew = ActiveSheet.Buttons.Add(Left:=63, Top:=1, Width:=60, Height:=49)
cmdNew.Caption = "Start Log"
cmdNew.OnAction = "ShowForm"
Set cmdNew = ActiveSheet.Buttons.Add(Left:=125, Top:=1, Width:=60, Height:=49)
cmdNew.Caption = "Stop Log"
cmdNew.OnAction = "ActionStop"
...
End Sub |
Partager