I have an old macro (12/96). I've upgraded the spreedsheet that uses it and
now it only runs on the computer used to upgrade it. It has to run on other
computers. I get complie error: can't find project or library. The debuger
is pointing to CurDir(). I went back and looked at the old spreadsheet and
under tools there is a refenence menu option, with the new spreedsheet it's
grayed out. I think the problem is the vba library is not getting loaded.
How can I fix this error.

Thank for any help
Brian...

Hit the reset button, then the reference button shouldn't be grayed out.
Then you can go in and fix the references.

--
Regards,
Tom Ogilvy

"brian" wrote in message
...
I have an old macro (12/96). I've upgraded the spreedsheet that uses it
and
now it only runs on the computer used to upgrade it. It has to run on
other
computers. I get complie error: can't find project or library. The
debuger
is pointing to CurDir(). I went back and looked at the old spreadsheet
and
under tools there is a refenence menu option, with the new spreedsheet
it's
grayed out. I think the problem is the vba library is not getting loaded.
How can I fix this error.

Thank for any help
Brian...

thank you Tom

Brian...

"Tom Ogilvy" wrote:

Hit the reset button, then the reference button shouldn't be grayed out.
Then you can go in and fix the references.

--
Regards,
Tom Ogilvy

"brian" wrote in message
...
I have an old macro (12/96). I've upgraded the spreedsheet that uses it
and
now it only runs on the computer used to upgrade it. It has to run on
other
computers. I get complie error: can't find project or library. The
debuger
is pointing to CurDir(). I went back and looked at the old spreadsheet
and
under tools there is a refenence menu option, with the new spreedsheet
it's
grayed out. I think the problem is the vba library is not getting loaded.
How can I fix this error.

Thank for any help
Brian...