Custom Footer - Printed by...- how to

[Mada]

How to add to custom footer information such as - who was printed this document?
Thanks in advance
Mada

[Paul]

Hi Mada,

This code should do what you're looking for. Copy this and paste it into the VBA code window for ThisWorkbook:

Please Login or Register  to view this content.

The first Footer line will set the Left Footer to show "Printed by:" and the EXCEL user name that you can see by going to Help -> About -> This product is licensed to: "someone's name". This will not change no matter who is logged into the computer at the time.

The next line will set the Right Footer to show "Printed by:" and the WINDOWS user account that is logged into the computer/network at the time of printing. This will change depending on who is logged into the PC at that time.

Simply remove one of the two lines if you don't want both to show up (or change them around, etc.) Have fun!

[Mada]

Hi Paul; Thank you very much - it works perfectly.
i have only one more question. These code woks for active worksheet.
How/what to modify to print it on all printed sheets.
Let say I group three sheets and I like to have it on all of them.
Thanks in advance
Mada

[Paul]

Hi Mada,

To have this info appear on all sheets, including grouped sheets, change the code to this:

Please Login or Register  to view this content.

[Mada]

Thanks a lot again
Regards
Mada