New "Unable to set the CentreHeader property of the PageSetup class" error

[Goobersdad1969]

I've had this piece of code in my Personal macro file for years and I've never had any issues with it:


Sub Header_Footer()

' Set centre header to display worksheet name and centre footer to
'display network file path and workbookname

With ActiveSheet.PageSetup
.CenterHeader = "Worksheet name: &A"
.CenterFooter = "Filepath: &Z&F"

End With

ActiveSheet.PrintPreview

End Sub

I've just tried to run it against a workbook someone else sent to me, and I got the error message in the title.

When I debug, it highlights the:

.CenterHeader = "Worksheet name: &A"

line

Any thoughts what could be causing this?

[rorya]

Do you have a default printer set?

[Goobersdad1969]

Yes, but it's a network print queue type thing (Follow-You on a network)

Could that be the problem??

[rorya]

That should be fine as long as it’s available. Can you actually print to it currently?