There is probably more to the error message than that. Please give the full
error message.

In addition, if a "debug" option is offered, select it and show us the
highlighted line of code.

However, you might be able to find it from the VB environment (ALT-F11).

In 2000, go to Tools/References and look at the references that are ticked.
Chances are that one or more of them will say "missing". These need to be
available to Excel before the sheet can be used. There are two options:

- Look down the list of available references to find one that matches the
missing one, but presumably an earlier version. Tick that and then see how
you go.

- If there is no matching unticked reference, then you'll need to install it
from elsewhere. Search with Google and it'll probably lead you to the
needed information.

I think technically, the it isn't a Excel 2000 problem.
The problem  is, the library is not found... this can happen regardless
of the version of Excel. The solution is to install the library!
First, make a note of WHICH library is not found, then
Open VBA and Select Tools -> References.
Look for the missing library and select it.
If you don't find it in the list, you may have to do an internet search
(most likely, it's a standard library that microsoft.com will have),
download it, then use Tools -> References to browse to it..