自己做个打印按钮
Sub myprint()
Dim x As String
If Application.Dialogs(xlDialogPrint).Show = True Then
x = Sheet1.Range("A1")
x = x + 1
Sheet1.Range("A1") = x
End If
End Sub
生成单号就在thisworkbook插入下边的代码就可以了
Private Sub Workbook_Open()
Dim a As String
Sheet1.Range("A1").NumberFormatLocal = "@"
If Month(Date) < 10 Then
a = Year(Date) & 0 & Month(Date) & Day(Date) & "0001"
Else
a = Year(Date) & Month(Date) & Day(Date) & "0001"
End If
If Left(Sheet1.Range("a1"), 8) <> Left(a, 8) Then
Sheet1.Range("a1") = a
End If
End Sub
追问代码插入没反应啊,还需要怎么设置吗,还有打印按钮怎么做啊,谢谢啦
追答不会插入按钮 直接执行宏也可以
下边的代码 要重新打开的时候才执行