本帖最后由 苗凱 于 2014-2-24 14:14 编辑
- Private Sub CommandButton1_Click()
- If MsgBox("真的需要保存及打印吗?", 4, "打印确认") = 7 Then Exit Sub
- Sheet2.Select
- <span style="color: rgb(17, 17, 17); font-family: Tahoma, Helvetica, 'Microsoft Yahei', SimSun, sans-serif, Hei; background-color: rgb(243, 249, 246); "> Sheet2.PrintOut Copies:=1, Collate:=True</span>
- <span style="color: rgb(17, 17, 17); font-family: Tahoma, Helvetica, 'Microsoft Yahei', SimSun, sans-serif, Hei; background-color: rgb(243, 249, 246); ">Sheet2.Visible = False</span>
- Application.Dialogs(8).Show
-
- Sheets("录入").Select
- End Sub
复制代码 楼主试试看看
|