如何用一段VBA代吗锁定EXCEL工作表中A1:E100不能打印.? 请大侠给看一看.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
rg = ActiveSheet.PageSetup.PrintArea
If Not Range("a1:e100 " & rg) Is Nothing Then Cancel = True
End Sub
rg = ActiveSheet.PageSetup.PrintArea
If Not Range("a1:e100 " & rg) Is Nothing Then Cancel = True
End Sub
温馨提示:答案为网友推荐,仅供参考