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

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

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

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

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

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

If not, remove it.


Gord Dibben MS Excel MVP

On Sat, 19 Aug 2006 09:54:02 -0700, Deb-in-Wisconsin
wrote:

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