Excel - Workbook_BeforePrint doesn't work?

Question

Here's my code:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = "Owner: " & Range("d24").Value
End Sub

I've also run Application.EnableEvents = True in a separate macro, but it still doesn't work.

My macros are enabled.

Any other ideas? Does it matter how I start printing? I've clicked print icon, click File/Print, printed from a print preview

Answer 1

It works with mine.

Did you put this inside thisworkbook module? Such events are trapped there.

Answer 2

it is simple, you need to set the sheet name in the LeftFooter

Instead of this
"Owner: " & Range("d24").Value
do this
"Owner: " & Sheet1.Range( "d24").Value
or this
"Owner: " & Worksheets( "Sheet1").Range( "d24").Value

and you are done,
Workbook events all need to set a sheet name to reference

Enjoy my profile, I am the VBAXLMan