Reference Cell in Page Header Using VBA - Excel 2007

I tried inserting what I have quoted below on the VBA Editor Worksheet: BeforePrint and do not see any changes. Is it something I should see populate the header field in page layout view, or will I have to view via print preview in order to see the name?

Yes, the plan is to change the name on a regular basis so that custom price pages may be printed for various prospects, so what would I need to do to run the macro and update the header, please?

Many thanks!!

Originally Posted by Greg M

Hi there!

Try inserting the following code into a standard VBA Code Module and see if it does what you want:

    Dim wks As Worksheet

    For Each wks In ThisWorkbook.Worksheets
        wks.PageSetup.LeftHeader = ThisWorkbook.Worksheets("Master").Range("A3").Value
    Next wks

End Sub

alansidman: I am absolutely embarrassed over here. Thank you for correcting my post. I will pay much more attention next time.