Adding formula to header or footer

[billfinn]

I did some research on this and found some info that it could only be done using BeforePrint. Can anyone tell me exactly how I go about that? I found the syntax but what I don't know is how it gets activated. I assumed that printing the file would activate the macro and the header would be populated with the value of A1 from the "Not in Dump File" worksheet
This is the code I found online with my worksheet entered in place of Sheet1

Private Sub Workbook_BeforePrint(Cancel As Boolean)


    With Worksheets("Not in Dump File").PageSetup
        .CenterFooter = Worksheets("Not in Dump File").Range("a1")
    End With
End Sub

I appreciate any guidance,
Bill

 

[Tetra201]

Try placing the sub into ThisWorkbook code section.

 

[billfinn]

Thank you very much!
Bill

 

[Tetra201]

You are welcome.