macro that runs when print page

  • Thread starter Thread starter venusc
  • Start date Start date
V

venusc

Is it possible to set a macro to run when a worksheet is printed?
Somewhat like an auto_open macro runs when the worksheet is opened.
Thanks all.
 
Venus,

Use the Workbook_BeforePrint event in ThisWorkbok code module, and put your
code in there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top