Tip of the week from 08 Sept 2001
Posted by Dan Weil on October 11, 2001 4:37 AM
Dear Mr. Excel and colleaques. I send again this message, since I did get no followups for the former. In Tip of the week from 08 Sept 2001, in reply to Donna, you gave instruction for writing "BeforePrint" event handler which will add full path of the file in the header (or footer. I tried it and it worked nice, thank you. I inserted this event handler in my Personal.xls workbbook, hoping that this macro will be available and will function for all opened other workbooks, but it did not.
Is there a way to apply the "BeforePrint" event handler for all opened workbooks?