Check user who prints certain docs

  • Thread starter Thread starter Johnniec
  • Start date Start date
J

Johnniec

Hi,

I've done a trawl through the newsgroup and have been unable to find any
help....

I have a macro which sends info to a text (.txt) file (i.e. the users
network login account number plus date & time) when a Doc is opened and/or
closed but what I would like to be able to do is send that same info but
this time would show when the file is printed out.

Can any kind soul send some VBA code which would do that (or point me in the
right direction....)

Many thanks

Johnnie
 
Johnnie,

If you lookup 'workbook object events' in VBA help, you will see some info
on workbook events, and a list of events. One is BeforePrint, just add your
code to that event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
OK, Workbook_BeforePrint; thanks for the heads up.

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub
 
Thanks Bob (simple when you "think" it through...)

(ps. They sure are changing the "face" of Poole Harbour" ain't
they..........)

But the Black fish/shrimp huts seem A.O.K. to moi.

Johnnie
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
They are, and it's not for the better IMO. Gentrification is dull
standardisation which drives out the local people. A dull marina, no Poole
Pottery anymore, a futuristic bridge over Holes Bay ... why?

Regards

Bob
 
Back
Top