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.