Use this in a workBOOK module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name < "Sheet1" Then
MsgBox "You may print only Sheet1"
Cancel = True
End If
End Sub

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"joemeshuggah" wrote in message
...
is it possible to program excel to prevent printing of specified tabs? i
have users that are too lazy to select the tab they want to print and are
printing tabs that have source data for pivot tables and wind up printing
pages upon pages that they don't need.