Check to see which one(s) are missing.

You may not even have them available.

Open VBE and ToolsReferences to have a look.

Could be a reference to an Add-in no longer available or any number of items.


Gord Dibben MS Excel MVP


On Sun, 18 May 2008 12:35:00 -0700, MG wrote:

I've developed a spreadsheet with macros in an older version of excel. When
I bring it into a newer version of excel, the macros fall down immediately
with the following error message: Compile error: Can't find project or
library. Is there a way of automatically loading the appropriate libraries
when the spreadsheet is opened?