Workbook_Before P_rint()

[Exeler]

I'm stuck.... I want to use VB to add a Header before it prints. Here is my code, but I print and it doesn't work... IFSPB & IFSPB are my sheet names... I must be overlooking something because this seems like it should work.... Can anyone help? I'd really appreciate it!

Private Sub Workbook_BeforePrint(Cancel As Boolean)

IFSPB.FirstPage.LeftHeader.Text = vbCr & "&""Times New Roman,bold""&12" & "Child's Name:  " & Worksheets("IFSPA").Range("M10").Value

End Sub

 

[Exeler]

Workbook Before_Print

Works!!! Needed to put code in "ThisWorkbook"

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Worksheets("IFSPB").PageSetup.FirstPage.LeftHeader.Text = vbCr & "&""Times New Roman,bold""&12" & "Child's Name:  "
End Sub