I am using Excel 2000 with Windows XP Home SP2 and am doing a workbook with
8 sheets. All is well with 6 of the sheets, but when I use print preview on
the other 2 I get a message:

Run-time error 50290 Method 'FullName' of object '_Workbook' failed

Debugger shows:

Microsoft Excel Objects

This Workbook

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterFooter = "&10" &
LCase(ActiveWorkbook.FullName)
End Sub

Actually when I get the error message and hit end instead of debug, it does
the print preview. Then if I hit print, I get the same error message. But
similarly, if I hit end, it prints.

It's an annoyance since it only adds a couple of steps to getting a print.
However, it would be nice to know how to fix it.

Thanks