Although this has never happened to me the many times I've used different
Excel versions, I'd suggest you open the workbook in Excel 2000, remove the
problem reference, add a reference to Office 2000 and save it.

--
Jim
"Nigel" wrote in message
...
| Hi,
| can anyone here adivse me on what to do. I have now finished my project
and
| it works exactly as i want it too. However, i have come across this very
| large problem.
| Introducing the book onto our server where everyone else uses excel 2000.
I
| created this book on excel 2003. So when someone else issues a macro they
| immediately get an error saying Object not found.
| i went into the Visual Basic Editor / References and looked for the office
| library but it says:
| MISSING.Office 11 object library.
| Is there a way around this or have i just wasted my time on this book? Can
i
| copy over the office 11 object library, or save this book as an earlier
| edition?
| or, do i have to upgrade everyone to office 2003?
|
| please advise.
|
| Very Frustrated Nige