I am creating an Excel workbook with lots of VBA code. I cam creating this
in Excel 2000 (aka Version 9). At least 90 % of the employees at my site use
Excel 2000. However, whenever my boss opens the workbook, the references get
changed for his use. He uses Excel 2003 (aka Version 11). When I go back in
the reference is broken. I cannot find Microsoft Office 11, naturally.

It seems the references change automatically when the user has a newer
version of Office, but not so when the user has an older version of Office.

I'm not so concerded about my boss breaking my reference, but when the
product is rolled out, I expect this to happen even more. The prodect will
be placed on the interned, the authorized users will download it to their
desktop and run from there.

How can I fix this problem? How can I make the reference upgrade work in
both directions of versions? Maybe I don't really have a problem and don't
realize it?

Thanks