|
如何
If ChkPrint Then
ChkPrint.Caption = "打印"
ChkPrint.BackColor = RGB(255, 255, 0)
ChkPrint.ForeColor = RGB(0, 0, 0)
Else
ChkPrint.Caption = "不打印"
ChkPrint.BackColor = RGB(192, 192, 192)
ChkPrint.ForeColor = RGB(128, 128, 128)
End If
End Sub
如何加入指定的打印机机设置
类似这个代码
If Application.Dialogs(xlDialogPrinterSetup).Show Then _
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
|
|