disable printer so worksheets CAN'T print accidentally???

D

Deb-in-Wisconsin

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
 
J

Jim Cone

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"
<[email protected]>
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
 
G

Gord Dibben

Do you need the beforedoubleclick event code that is sending the command to the
printer?

If not, remove it.


Gord Dibben MS Excel MVP
 
Top