kblake,
How about:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim WS As Worksheet
For Each WS In ActiveWindow.SelectedSheets
If WS.Name = "Banned Sheet" Then
MsgBox "Printing of " & WS.Name & " is not allowed."
Cancel = True
Exit Sub
End If
Next
End Sub
Or use Application level events for the same.
However this also PrintPreview, which maybe a problem.
NickHK
"kblake" <kblake@discussions.microsoft.com> wrote in message
news:A72D0646-3004-4690-8EC5-7B2F3D369F3D@microsoft.com...
> I need to disable the Print command in 11 out of 15 sheets (tabs) in a
single
> document. I have the VB script for disabling printing for the entire
document
> but I would like to know if it is possible the disable printing on
selected
> sheets.
> Thanks...
Bookmarks