Did you try Tools/References and selecting VBA Project (Funcres) in the
VBE?

In article .com,
"cuboid" wrote:

I have a PC spreadsheet with some VBA macros that won't compile on a
Mac with Office 2004. Spreadsheet was written with Excel2000 on a Win2K
machine.

he compile error is about a missing library, and it's looking for
FUNCRES.XLA. I have the Analysis ToolPak loaded (which, on the Mac, has
FuncRes, without any extension) and it still won't compile.

Is there a workaround/fix for this or are we doomed to not being able
to share spreadsheets from PCs to Macs?

thanks
CB