On 2002-08-22 19:22, PaddyD wrote:
You'll need to set them in a macro the runs before the workbook is printed. What do you want in the header?
Paddy
On 2002-08-22 20:37, brettvba wrote:
do you mean,
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "Check Header Or Footer!"
End Sub
Put that code in the ThisWorkbook modue in VBE
Brett