Stop Printing

[D A N]

Hello
In a bid for Sustainable working (reducing my companies carbon footprint)
i'm trying to limit the amount of printing done on my network.
i can block printing using VBA in Excel but i'm scoobied about how to do it
in word
any ideas ?

 

[Pranav Vaidya]

The way you can do this is use the Application object's event called
'DocumentBeforePrint'.

This event occurs before activedocument is printed, so you can checkyour
validations. For more details on how to trap the applicationlevel events see-
http://msdn2.microsoft.com/en-us/library/aa140934(office.10).aspx

HTH,

 

[Jonathan West]

Hello
In a bid for Sustainable working (reducing my companies carbon footprint)
i'm trying to limit the amount of printing done on my network.
i can block printing using VBA in Excel but i'm scoobied about how to do
it
in word
any ideas ?

An alternative idea to Pranav's is to create two macros as follows

Sub FilePrint()
MsgBox "Sorry, printing not allowed here"
End Sub

Sub FilePrintDefault()
MsgBox "Sorry, printing not allowed here"
End Sub

Place the macros in a template, and load the template as an add-in by
putting it in Word's Startup folder.