I managed to sort the problem by coping the items ticked in the reference box
from the tool menu and it works now.
--
Bob


"Bob" wrote:

Thanks for getting back to me Jon, I am not with the computer in question at
the moment but I will send you the list later on.
--
Bob


"Jon Peltier" wrote:

What were the missing references? Maybe we can systematically go through the
list.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Bob" wrote in message
...
Hi Jon,
I followed your instructions and there were alot marked as missing. I
ticked
all of them then tried the file the following message came up:
compile error cant find object library.
I then checked reference again and found all missing agian. I then checked
the object library and tried again and the following message came up:
name conflict with project & object library.
--
Bob


"Jon Peltier" wrote:

In the VB Editor, go to Tools menu References. Are there any items
marked
[MISSING]?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Bob" wrote in message
...
Sorry it should say
Cant find project or object library
--
Bob


"Bob" wrote:

It says something like:
cant recognize Project or Object Library
--
Bob


"Ron de Bruin" wrote:

Post the debug code line Bob


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Bob" wrote in message
...
I have a file with macro done using excel office 2003. I have tried
it
on a
computer with office 2007. When I run the file it keeps debugging.
Is
there a
way to make this file compatible with office 2007.
--
Bob