查了下资料,多vba不熟,只做到不允许打印和打印预览这个功能。
全局代码
Public Sub Workbook_BeforePrint(ByRef Cancel As Boolean)
msgbox("不能打印")
cancel = True
End Sub
调用代码
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open("D:\test.xls")
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
App.Visible = True
addhandler Wb.BeforePrint, addressof Workbook_BeforePrint
'Ws.PrintPreview()
'App.Quit
[此贴子已经被作者于2014-2-15 20:39:13编辑过]