Linking Header&footer to sheet and protecting

Good morning skatmandu2002

There is no way to protect the header and footer so that they cannot be changed, however there is an event called Before_Print that will capture when a user is going to print a document. You need toi intercept this and set the header / footer as you wish :

Put this code into your ThisWorkbook module :

Please Login or Register  to view this content.

Just modify to set which headers / footers you want to show.

HTH

DominicB