Take a look he

http://www.mcgimpsey.com/excel/fullnameinfooter2.html

In article ,
"Chrisod" wrote:

Please help? When I create a custom header or footer I have to do it for
every worksheet in Excel. Is there any way I can force it to add it to all
worksheets?