If it's really important to you, you could use a workbook_beforeprint event
macro that recreates the header/footer each time print (or print preview is
invoked).
But this will fail if the user disables macros or even disables events.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
