Hi there,

My company is in the process of gradually replacing employees'
computers, going from Windows 2000 to XP (not sure which edition of XP,
I don't have one of the new machines yet). Regardless of Windows
version, everyone seems to be running Excel 2002 SP3.

I have a multi-user (single copy, opened read-only) Excel workbook to
which I recently added code to set part of the page header as each
sheet is opened. This is done in the ThisWorkbook module using the
function Worksheet_BeforeActivate:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Sh.PageSetup.RightHeader = [what we want RightHeader to say]
End Sub

So far this has worked fine, including for a few users who are running
Excel 2002 on Windows XP. However, in setting up a new user's machine
today, our IT department found they were getting an error when this
code executed, along the lines of "Run-time error 1004: Unable to set
the RightHeader property of the PageSetup class".

I've searched but haven't found anything to suggest a reason why this
would work on some computers and not others... I don't see anything in
the options or settings jumping out at me... Macro security has to be
at medium (or low, but we discourage that) for the program itself to
work (navigation is done via macro buttons and hyperlinks) so that has
to be consistent across the board... There are no missing references in
the VBA on the machine where the error is occurring... IT even wiped
and reinstalled everything on the machine with the error.

Any suggestions would be most appreciated... Thank you!

Matt