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

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"
<Deb-in-Wisconsin@discussions.microsoft.com>
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

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
<Deb-in-Wisconsin@discussions.microsoft.com> 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