Tom:

Why is this happening? I notice this issue quite frequently here, and am wondering if MS
blew it when they released Excel 2003. This kind of reverse compatibility issue should not
happen in a well designed upgrade, should it?

Best

John Baker

"Tom Ogilvy" wrote:

in the VBE, make the workbook with the code the active project (select it in
the project explorer). Go to Tools=References in the menu and see if you
have any references shown at the top as MISSING.

If so, you need to either find the referenced file on your computer, or
remove the reference if your are not using it.