Use this code in the "ThisWorkbook" module for the particular workbook...

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
'-----------
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Deb-in-Wisconsin"

wrote in message
I'm having trouble with a mouse that sometimes double clicks while I'm in a
cell in an Excel worksheet, and suddenly find my printer being commanded to
print the worksheet's 1800+ pages....YIKES!!!!!

Mayday! Mayday!

How do I turn OFF the printing function for large worksheets that I'll never
have a need to print?

THANKS,
Deb in Wisconsin