Hi Alan,

yes, it can be done.

With that I know from your post, I am not able to write any code
example. So I have to repeat my advice: explore workbook_before print
event in VBA help.

Regards,
Ivan