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