Hi all,

I have a macro that I want to run every time I print:
  1. Reference Sheet4
  2. Find the latest date in Column 7
  3. Insert that date into the text string in the Sheet3 header
  4. Proceed to Print Preview

I have this code set up under the 'ThisWorkbook' node:
Please Login or Register  to view this content.
If I break out the macro as a separate Module and run it manually, it works (as shown below)... But it will not run automatically when I open print preview or send to the printer. I've tried pasting the entire code inside the Workbook_BeforePrint string (as shown above) and referencing AddHeader, without success. What am I doing wrong?

Please Login or Register  to view this content.
Thanks and have a great day!