Hi all,
I have a macro that I want to run every time I print:- Reference Sheet4
- Find the latest date in Column 7
- Insert that date into the text string in the Sheet3 header
- Proceed to Print Preview
I have this code set up under the 'ThisWorkbook' node:
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?
Thanks and have a great day!
Bookmarks