Stop Printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D A N - 05 Sep 2007 14:56 GMT

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 ?

Reply to this Message

Pranav Vaidya - 05 Sep 2007 16:14 GMT

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,

Signature

Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!

> 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 ?

Reply to this Message

Jonathan West - 05 Sep 2007 19:21 GMT

> Hello
> In a bid for Sustainable working (reducing my companies carbon footprint)
[quoted text clipped - 3 lines]
> 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.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message