Dear all,
I have an macro that format header & footer and it runs smoothly when I paste this macro to the workbook that I want to print.
The problem is that I would like this macro to execute whenever any excel files printed. It means that I don't like to paste this macro to any work book, it automatically runs whenever any excel file is printed.
Could any one help me?
Thanks a lot!
Nam
Bookmarks